Deletes Active Worksheet (without a warning being displayed to User)
:
Return to List
' Deletes worksheet without warning and without first saving it!
Sub DeleteActiveSheet()
Application.DisplayAlerts = False
ActiveSheet.Delete
Application.DisplayAlerts = True
End Sub
See also:
Activate Worksheet by Name
Activates the First Worksheet
Activates Last Worksheet
Adding a Worksheet
Copying one worksheet to another
Counting and Selecting Worksheets
Moving worksheet to particular location (i.e., order)
Naming the active worksheet
Note to Webmaster