delete tab
 

what code deletes sheet1 without giving the pop up box
confirming you want to delete the tab?

Thank you.

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.

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.