» Delete sheets without confirmation prompts using VBA in Microsoft Excel

VBA macro tip contributed by Erlandsen Data Consulting offering Microsoft Excel Application development, template customization, support and training solutions

CATEGORY - Files, Workbook, and Worksheets in VBA VERSION - All Microsoft Excel Versions

If you want to delete sheets from a workbook without the user being prompted for any
confirmations you can use this macro:

Sub DeleteSheet(strSheetName As String)
' deletes a sheet named strSheetName in the active workbook
    Application.DisplayAlerts = False
    Sheets(strSheetName).Delete
    Application.DisplayAlerts = True
End Sub