Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Sheet without message box
Hello,
I want to delete a worksheet, but upon doing so a message box pops up informing the user that the sheet will be deleted, giving OK and Cancel options. How do I suppress this message box? I have screened the application object for a switch but have not figured out what to do. Thank you so much for your help!! Oliver |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Sheet without message box
application.displayalerts = false
worksheets("sheet99").delete application.displayalerts = true "Mr. T" wrote: Hello, I want to delete a worksheet, but upon doing so a message box pops up informing the user that the sheet will be deleted, giving OK and Cancel options. How do I suppress this message box? I have screened the application object for a switch but have not figured out what to do. Thank you so much for your help!! Oliver -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Sheet without message box
Application.DisplayAlerts = False
Sheets("Whatever").Delete Application.DisplayAlerts = True "Mr. T" wrote in message s.com... Hello, I want to delete a worksheet, but upon doing so a message box pops up informing the user that the sheet will be deleted, giving OK and Cancel options. How do I suppress this message box? I have screened the application object for a switch but have not figured out what to do. Thank you so much for your help!! Oliver |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep sheet from deleting contents | Excel Worksheet Functions | |||
Deleting every-other row in a spread sheet | Excel Discussion (Misc queries) | |||
Deleting Sheet | Excel Programming | |||
Deleting a Sheet | Excel Programming | |||
Deleting a Prompt Message | Excel Programming |