Try
Application.DisplayAlerts = False
your code
Application.DisplayAlerts = True
Regards,
Alan.
"MatthewT" wrote in message
...
I want to delete a worksheet as part of a VBA project. How do I disable
the prompt asking if you are sure you want to delete it? I want to
take away this control from the user just within the project.
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/