Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
To suppress the dialogue box put the following Application.DisplayAlerts = False ActiveWindow.SelectedSheets.Delete Application.DisplayAlerts = True For more information look in the VBE help file. Regards Paul "FireatHome" wrote in message ... In VBA I delete a sheet with this command: "ActiveWindow.SelectedSheets.Delete" I get a msgbox where I have to "OK" to perform the delete. Q: How to delete without the msgbox |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automated shifts. Is it possible? | New Users to Excel | |||
Delete Duplicate Rows Macro Question | Excel Discussion (Misc queries) | |||
Quick Macro question - How to delete two rows then skip one - and repeat | Excel Discussion (Misc queries) | |||
Automated Reporting | Excel Worksheet Functions | |||
help: automated delete without question | Excel Programming |