Hints and tips home » VBA hints and tips » Suspend DisplayAlerts in VBA

Suspend DisplayAlerts in VBA

To stop Excel asking you things like "Do you want to delete this file...", use the following line of code at the beginning of the relevant VBA procedure:

Application.DisplayAlerts = False

At the end of the procedure make sure you use the following code to reactivate Display Alerts:

Application.DisplayAlerts = True

Added by Carlos on 24th November 2006

More VBA hints and tips, like:

• Add A New Sheet at the end of the Workbook
• Stop Screen Flickering When Running Code
• Use GoTo to Select A Cell With VBA