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