Daily tips for using Microsoft Excel.

Thursday, November 29, 2001

Hope to have the message board back tomorrow.

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