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.
Using the Worksheet Host Item
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.
Globals.Sheet1.Visible = Excel.XlSheetVisibility.xlSheetHiddenGlobals.Sheet1.Visible = Excel.XlSheetVisibility.xlSheetHidden;
Using the Sheets Collection of the Excel Workbook
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.
CType(Globals.ThisWorkbook.Sheets(1), Excel.Worksheet) _ .Visible = Excel.XlSheetVisibility.xlSheetHidden((Excel.Worksheet) Globals.ThisWorkbook.Sheets[1]) .Visible = Excel.XlSheetVisibility.xlSheetHidden;
See Also
Tasks
How to: Programmatically Delete Worksheets from Workbooks
How to: Programmatically Move Worksheets Within Workbooks
How to: Programmatically Protect Worksheets