J jrh Oct 14, 2003 #1 what code deletes sheet1 without giving the pop up box confirming you want to delete the tab? Thank you.
what code deletes sheet1 without giving the pop up box confirming you want to delete the tab? Thank you.
P Peo Sjoblom Oct 14, 2003 #2 Application.DisplayAlerts = False Worksheets("sheet1").Delete Application.DisplayAlerts = True
R Ron de Bruin Oct 14, 2003 #3 Try this Jrh Application.DisplayAlerts = False Activesheet.Delete Application.DisplayAlerts = True