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
Application.DisplayAlerts = True

Bill Jelen is the author / co-author of
MrExcel LX – The Holy Grail of Excel Tips

A book for people who use Excel 40+ hours per week. Illustrated in full color.