Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete tab
what code deletes sheet1 without giving the pop up box
confirming you want to delete the tab? Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete tab
Application.DisplayAlerts = False
Worksheets("sheet1").Delete Application.DisplayAlerts = True -- Regards, Peo Sjoblom "jrh" wrote in message ... what code deletes sheet1 without giving the pop up box confirming you want to delete the tab? Thank you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete tab
Try this Jrh
Application.DisplayAlerts = False Activesheet.Delete Application.DisplayAlerts = True -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "jrh" wrote in message ... what code deletes sheet1 without giving the pop up box confirming you want to delete the tab? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete the test values, but do not delete the formulas | Excel Discussion (Misc queries) | |||
How can I delete a macro when the Delete button is not active? | Excel Worksheet Functions | |||
How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions |