Thread: Disable Prompts
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan Alan is offline
external usenet poster
 
Posts: 492
Default 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/