Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Worksheet Delete Warning
Greetings:
When my VBA macro deletes one of the worksheets in my workbook (through the Sheet.Delete method), I get the following warning: "Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press Delete." I then have to click on the Delete button to proceed with the action. Is there any way to suppress this annoying warning so that the worksheet will automatically get deleted? Respectfully, Charles |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Worksheet Delete Warning
precede it with
Application.DisplayAlerts = False and reset to True after. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Charles in Iraq" wrote in message ... Greetings: When my VBA macro deletes one of the worksheets in my workbook (through the Sheet.Delete method), I get the following warning: "Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press Delete." I then have to click on the Delete button to proceed with the action. Is there any way to suppress this annoying warning so that the worksheet will automatically get deleted? Respectfully, Charles |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using VBA how can I delete a worksheet w/o the warning message pop | Excel Discussion (Misc queries) | |||
Disable Warning | Excel Programming | |||
Disable Security Warning | Excel Programming | |||
Disable Worksheet Delete Dialog | Excel Programming | |||
disable warning messages? | Excel Programming |