| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Supress "delete sheets" warning
Hi
Use this Sub test() Application.DisplayAlerts = False ActiveSheet.Delete Application.DisplayAlerts = True End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "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) | |||
| How2 Delete "Not exist" charts/sheets? | Excel Programming | |||
| Supress "now printing" message | Excel Programming | |||
| Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming | |||
Linear Mode
