MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Deleting sheets

Posted by Bill on July 23, 2001 5:30 PM

How can i remove the need to "confirm deletion" of sheets when doing it via a macro - the macro recorder does not record this step?

Posted by Russell H. on July 23, 2001 6:09 PM


Sandwich your code between the lines:

Application.DisplayAlerts = False
' code
Application.DisplayAlerts = True