Tip Printed from ExcelTip.com
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



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