MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Delete a Worksheet in a Macro Without Delete Confirmation


October 23, 2001 - by Bill Jelen

Charlie asks:

Is there a way in VBA to remove a worksheet which will bypass the "The selected sheets will be permanently deleted. Click OK" prompt?

This particular message is one that can be suppressed by using the Application.DisplayAlerts property.

Use the following code:

Application.DisplayAlerts = False
Worksheets("MySheet").Delete
Application.DisplayAlerts = True