Hints and tips home » VBA hints and tips » Stop Display Alerts In Excel

Stop Display Alerts In Excel

When creating or deleting a Worksheet in Excel you don't want Excel to inform you "A file already exists....." Or "Do you want to save this file...".

To stop these alerts happening use the following line of code:

Application.DisplayAlerts = False

After the Create or Delete routine use:

Application.DisplayAlerts = True

Added by Carlos on 7th November 2006

More VBA hints and tips, like:

• Count the Rows and Columns in a Selection
• Empty The Clipboard with CutCopyMode
• Stuck in a Code Loop