I don’t like the confirmation dialog…Can I kill (Excel 2002)

Topic

New Reply

I am trying to run the following an a macro in Excel and it pops up a dilog asking for confirmation.

Sheets("Written Instructions").Delete

Can I turn off the dialogs in Excel similar to DoCmd.SetWarnings False in Access?

Reply | Quote

Replies

Use

Application.DisplayAlerts = False
Sheets(“Written Instructions”).Delete
Application.DisplayAlerts = True

Andrew C

Reply | Quote

Man…

For the first time ever I think I used the object browser and saw Application.Dialogs but somehow missed .DisplayAlerts

Thanks for the assistance!!

Reply | Quote

Application.DisplayAlerts = False

Remember to reset to True; I think that is default when the routine is exited.

Reply | Quote