| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Supress "delete sheets" warning
Hi ConEddie,
Application.DisplayAlerts = False Sheets("Sheet2").Select ActiveWindow.SelectedSheets.Delete Application.DisplayAlerts = True Regards, Hari India "ConEddie" wrote in message ... Does anyone know how to supress the "The slected sheet(s) will be permanently delted" warning when deleting a worksheet from a wookbook? I would like to do it in the VBA code but if that's not possible, how about setting some workbook options? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete all sheets in workbook that contain "Dump" in the name | Excel Worksheet Functions | |||
| How do I delete Sheets if "Delete" is greyed out? | Excel Discussion (Misc queries) | |||
| Supress "delete sheets" warning | Excel Programming | |||
| How2 Delete "Not exist" charts/sheets? | Excel Programming | |||
| Supress "now printing" message | Excel Programming | |||
![Hari[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
