| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Worksheet Delete Dialog
I have a VBA macro that needs to delete a worksheet but the confirmation
dialog comes up when run. Is there a way to disable this dialog. Thanks, Greg |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable Worksheet Delete Dialog
Greg,
Try something like Application.DisplayAlerts = False ' your code here Application.DisplayAlerts = True -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Greg" wrote in message ... I have a VBA macro that needs to delete a worksheet but the confirmation dialog comes up when run. Is there a way to disable this dialog. Thanks, Greg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA to disable "Delete...." on shortcut menu of worksheet tab? | Excel Discussion (Misc queries) | |||
| How do you disable save file dialog? | Setting up and Configuration of Excel | |||
| Disable Dialog when following external hyperlink | Excel Programming | |||
| Disable Saveas Dialog | Excel Programming | |||
| Disable Clipboard Dialog Box during Macro | Excel Programming | |||
Linear Mode
