MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Deleting Multiple Sheets in Macro


Posted by Ed Jessen on September 21, 2000 8:45 AM

I'm deleting multiple sheets via a macro. Is there a way to avoid the manual verification for the deletion of each sheet?


Posted by JAF on September 21, 2000 8:54 AM

At the start of your macro you can use the following
sub delete_sheets()
Application.DisplayAlerts = False
'your code to delete required sheets here
Application.DisplayAlerts = True
end sub


JAF

Posted by Ed Jessen on September 21, 2000 9:11 AM

Thanks JAF

Just what I needed. Thanks for the quick response!