[RESOLVED] Avoid the “Are you sure you want to delete?” question

[Botillier]

Thanks to this forum I have been successful in creating a very time saving macro, now I am trying to clean it up. One thing that would make it nicer is to be able to avoid the warning “Are you sure you want to delete?” question. It pops up every time the macro deletes a worksheet, and the macro deletes a ton. Any suggestions?

[DKenny]

Have a look at Application.DisplayAlerts.

Make sure you turn it back on after your code has completed.

[DaveBo]

If you're actually in an Access macro, see the SetWarnings action

[Botillier]

DKenny, thanks for the tip

Application.DisplayAlerts = False
Application.DisplayAlerts = True