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

DisplayAlerts

Sandwich your code between the lines:

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