Hide an Excel worksheet and do not permit users to unhide
How to hide an Excel worksheet and restrict users from unhiding the hidden worksheet using VBA
Sub Hide_Worksheet()
'hide a worksheet
Worksheets("Data").Visible = xlSheetVeryHidden
Worksheets("Data").Visible = xlSheetVeryHidden
End Sub
OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
PREREQUISITES
Minimum Number of Worksheets: Have at least two worksheets in a workbook.
Worksheet Names: Have one worksheet named Data.
Minimum Number of Worksheets: Have at least two worksheets in a workbook.
Worksheet Names: Have one worksheet named Data.
ADJUSTABLE PARAMETERS
Worksheet Selection: Select any worksheet in the workbook that you want to hide by changing the Data worksheet name.
Worksheet Selection: Select any worksheet in the workbook that you want to hide by changing the Data worksheet name.
ADDITIONAL NOTES
Note 1: This will ensure that users cannot unhide the hidden worksheet and the hidden worksheet will not appear in the Unhide window. The only way that a user will be able to unhide the worksheet is through VBA.
EXPLANATION
This tutorial explains and provides step by step instructions on how to hide a worksheet and do not permit users to unhide using VBA.
This tutorial explains and provides step by step instructions on how to hide a worksheet and do not permit users to unhide using VBA.
VBA Method: Using VBA you can hide a worksheet and restrict user permission to unhide the hidden worksheet.