MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Bypass Delete Confirmation


November 29, 2001 - by Bill Jelen

Bill sends today's question:

How can I stop the confirmation box from needing to be clicked "OK" when deleting files or sheets called to be deleted within a MACRO under Excel 97.

Use the DisplayAlerts property:

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