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

Hi,
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 :-)

Adam


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

Hiya

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.


JAF