Delete Worksheet in Excel VBA

VBA delete worksheet Excel Macro Example Code helps to delete Worksheet in Exce while automating some kind of requests. For example, We may have the request to collate the data from different worksheets of the workbook. We do automate it and finally we we delete the unnecessary worksheets from the workbook.

• Delete Worksheet in Excel VBA – An Example
• Delete Worksheet in Excel VBA – Disable Application Alerts

VBA Delete Worksheet in Excel – Solution(s):

We can delete a Worksheet from a Workbook using Delete Method of the Worksheet in Excel VBA. The following examples will show you how to delete a Worksheet form Workbook.

Delete Worksheet in Excel VBA – An Example:

In this example, I am deleting a worksheet (named Sheet2).

Code:

Sub sbDeleteASheet()

Sheet1.Delete
'OR You can mention the Sheet name
Sheets("Sheet2").Delete

End Sub

Instructions:

1. Open an excel workbook
2. Insert 2 Worksheets and enter some data
3. Press Alt+F11 to open VBA Editor
4. Insert new module from the Insert Menu
5. Copy the above code and Paste in the code window
6. Save the file as macro enabled workbook
7. Press F5 to execute the code.

Output:

When you execute the above code, it will show you a warning message called application alerts. If you click on delete button it will delete the Worksheet.

Delete Worksheet in Excel VBA – Disable Application Alerts or Warning message:

While executing the above code, we got a warning message. If you want to avoid that warning message, you need to disable the application alerts. The following example will show you how to delete a Worksheet and stop showing warning messages.

Code:

Sub sbDeleteASheet()

'Stopping Application Alerts
Application.DisplayAlerts=FALSE

Sheet1.Delete
'OR You can mention the Sheet name
Sheets("Sheet2").Delete

'Enabling Application alerts once we are done with our task
Application.DisplayAlerts=TRUE

End Sub

Instructions:

1. Open an excel workbook
2. Insert 2 Worksheets and enter some data
3. Press Alt+F11 to open VBA Editor
4. Insert new module from the Insert Menu
5. Copy the above code and Paste in the code window
6. Save the file as macro enabled workbook
7. Press F5 to execute the code.

Output:

If you execute the code, now you will not see any alerts. Since we have disabled the application alerts.