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