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

<< Home