Disable Prompts
 

I want to delete a worksheet as part of a VBA project. How do I disabl
the prompt asking if you are sure you want to delete it? I want t
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

Disable Prompts
 

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/