Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save Prompts | Excel Worksheet Functions | |||
How to disable macro prompts for OK in Excel? | Excel Discussion (Misc queries) | |||
Prompts | Excel Discussion (Misc queries) | |||
formula prompts | Excel Discussion (Misc queries) | |||
Eliminating Prompts | Excel Programming |