How to: Programmatically Hide Worksheets
You can show or hide any worksheet in a workbook. To hide a worksheet, use the worksheet host item or access the worksheet by using the sheets collection of the workbook.
Applies to: The information in this topic applies to document-level projects and application-level projects for Excel 2013 and Excel 2010. For more information, see Features Available by Office Application and Project Type.
If the worksheet was added at design-time in a document-level customization, use the Visible property to hide the specified worksheet.
To hide a worksheet using a worksheet host item
-
Set the Visible property of the Sheet1 host item to the xlSheetHidden enumeration value.
Access worksheets through the Microsoft Office Excel Sheets collection in the following cases:
-
You want to hide a worksheet in an application-level add-in.
-
The worksheet that you want to hide was created at run time in a document-level customization.
To hide a worksheet using the Sheets collection of the Excel workbook
-
Set the Visible property of the worksheet to the xlSheetHidden enumeration value.
