[RESOLVED] Avoid the “Are you sure you want to delete?” question
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?
Re: Avoid the “Are you sure you want to delete?” question
Have a look at Application.DisplayAlerts.
Make sure you turn it back on after your code has completed.
Re: Avoid the “Are you sure you want to delete?” question
If you're actually in an Access macro, see the SetWarnings action
Re: Avoid the “Are you sure you want to delete?” question
DKenny, thanks for the tip
Application.DisplayAlerts = False
Application.DisplayAlerts = True