» 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
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
Book Store:
Recommended Books:
- Special Edition Using Microsoft Excel 2002
- Not-for-Profit Accounting Made Easy
- Microsoft Word Version 2002 Inside Out
- Microsoft Excel VBA Programming for the Absolute Beginner
- Microsoft Office XP Introductory Concepts and Techniques
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
Eddie.