Accepting the contents of a message box in VBA

[djurmann]

Hi folks,

I have created a macro that merges cells. A message box comes up saying "merging into one cell will keep the upper left most data only". I am happy with this. How do I either stop the box appearing or set the macro to automatically choose OK each time without me clicking?

Many thanks,

Danny

 

[Richard Schollar]

Hi Danny

Include the following line in your code:

Application.DisplayAlerts = False

you can turn alerts back on again (should you wish to do so) by switching it back to True.

Best regards

Richard

 

[djurmann]

Many thanks, that solved it nicely

Danny