Delete sheet automatic

  • Thread starter Thread starter David
  • Start date Start date
D

David

Hi Group,

I am trying to allow a sheet deletion with out having to manually click the
Delete button which comes up in the process.

Thanks,
David
 
Sub SheetDelete()
Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True
End Sub


Gord Dibben MS Excel MVP
 
Back
Top