Delete an active Excel worksheet
How to delete an active Excel worksheet using VBA and Shortcut methods
Sub Delete_an_Active_Worksheet()
'delete an active worksheet
ActiveSheet.Delete
ActiveSheet.Delete
End Sub
ADJUSTABLE PARAMETERS
Worksheet Selection: Select any worksheet in the workbook that you want to delete.
Worksheet Selection: Select any worksheet in the workbook that you want to delete.
WINDOWS SHORTCUT
Alt
H
>
D
>
S
NOTES
The shortcut will delete the active worksheet.
EXPLANATION
This tutorial explains and provides step by step instructions on how to delete an active worksheet using VBA and Shortcut methods.
This tutorial explains and provides step by step instructions on how to delete an active worksheet using VBA and Shortcut methods.
VBA Methods: Using VBA you can delete an active worksheet.
Shortcut Method: Using a Shortcut you can delete an active worksheet.