Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Just to be safe you should probably add
Application.DisplayAlerts = False on error resume next Sheets("Replace Info").Delete Application.DisplayAlerts = True or add this line into an existing error handler if you have one Application.DisplayAlerts = True Otherwise if the delete fails then you never turn the alerts back on whcih can be a bad thing... "Mike Fogleman" wrote: Application.DisplayAlerts = False Sheets("Replace Info").Delete Application.DisplayAlerts = True Mike F "Ken Loomis" wrote in message ... I am using this to delete a worksheet: Sheets("Replace Info").Delete however, that causes a warning dialog box. How can I delete that worksheet without a dialog box? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to delete the "Insert Function Dialog Box" (dialog box only)? | Excel Worksheet Functions | |||
changing options in delete dialog box | Excel Discussion (Misc queries) | |||
Disable Worksheet Delete Dialog | Excel Programming | |||
Dialog sheet / Checkboxes | Excel Programming | |||
Dialog Sheet not updating | Excel Programming |