MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How to turn off warning message when merge cells?

  Asked By: Bill    Date: Sep 24    Category: MS Office    Views: 15736

I recorded a macro that will format cells the way I want. The
problem is every time I get the following warning message:

The selection contains multiple data values. Merging into one cell
will keep the upper-left most data only.

I know it is caused by my merging some cells. And I don't want to
see this warning message any more. Is there a way I can turn it off
by inserting some codes?



3 Answers Found

Answer #1    Answered By: Miriam Green     Answered On: Sep 24

Place this line before the line which merges:

Application.DisplayAlerts = False

It is recommended to place this next line after the merging  is

Application.DisplayAlerts = True

since the the first line disables _all_ alerts.

Answer #2    Answered By: Alberta Miller     Answered On: Sep 24

Sometimes when I open the spreadsheet, a pop out window will ask me
to update or not. How to skip that choice and always update?

Answer #3    Answered By: Debbie Reyes     Answered On: Sep 24

Tools, Option, Edit Tab and uncheck the "Ask to update automatic link"

Didn't find what you were looking for? Find more on How to turn off warning message when merge cells? Or get search suggestion and latest updates.