How to: Hide Worksheets
The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office.
Microsoft Office version
For more information, see Features Available by Application and Project Type.
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.
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
Globals.Sheet1.Visible = Excel.XlSheetVisibility.xlSheetHidden
Globals.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
CType(Globals.ThisWorkbook.Sheets(1), Excel.Worksheet) _ .Visible = Excel.XlSheetVisibility.xlSheetHidden
((Excel.Worksheet) Globals.ThisWorkbook.Sheets) .Visible = Excel.XlSheetVisibility.xlSheetHidden;