Suppressing Built-In Excel Dialog /Notifcation Boxes? 2

[Phoenix22]

Hi,

Is there a way to suppress the Excel dialog/notification boxes that pop up asking the user to confirm or accept something (i.e. a box that pops up asking the user if they really want to delete a sheet or enable macros, etc)?

I'm writing a macro and would like to avoid having the user click "ok" for these dialog boxes.

Any advice or assistance would be appreciated, thanks for your help and time.

 

[atray04]

I believe that this line wioll solve your problem
Application.DisplayAlerts = False

 

[VBAjedi]

You may also be able to turn off the events that are causing the popups in the first place with:

Application.EnableEvents = False

Just remember to set it back to True when you are finished! Also, if your code errors out before it gets to the end, events will stay disabled until you reopen Excel.



VBAjedi