delete tab

jrh · Oct 14, 2003

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

Thank you.

Peo Sjoblom · Oct 14, 2003

Application.DisplayAlerts = False
Worksheets("sheet1").Delete
Application.DisplayAlerts = True

Ron de Bruin · Oct 14, 2003

Try this Jrh

Application.DisplayAlerts = False
Activesheet.Delete
Application.DisplayAlerts = True