Suppressing alert messages is useful when you want your MACRO to do things like delete a worksheet without user input. To turn off the message simply run:
Application.DisplayAlerts = False
Be sure to re-enable Alerts after you are done:
Application.DisplayAlerts = True
No comments:
Post a Comment