MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Merge/DeMerge Prompt

Posted by Adam a.k.a. Yellow Wizard on November 19, 2001 2:33 AM

I using a program that calls Excel and automatically does some calculations - the problem being is that this program is totally automated and because it is so it is supposed to run everything through Excel and export some data - now, Excel promps me to click either OK or Cancel to the merging or demerging of cells - because it does this the program then hangs and waits for someone (me) to click OK to continue, i cannot be there to do that so i need to turn off the prompt or just turn off all prompts im not fussed

let me know if this is possible

Thanks :-)


Posted by JAF on November 19, 2001 3:49 AM


If you start your code with the line Application.DisplayAlerts = False and finish it with the line Application.DisplayAlerts = True, then Excel won't display any alerts asking for confirmations.

Just make sure that you put the "True" line in at the end otherwise Excel won't display ANY alerts at all.