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 VSTO Add-in projects for Excel. 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.

1. Set the Visible property of the Sheet1 host item to the xlSheetHidden enumeration value.

   • C#
   • VB

   Globals.Sheet1.Visible = Excel.XlSheetVisibility.xlSheetHidden;
   

Access worksheets through the Microsoft Office Excel Sheets collection in the following cases:

• You want to hide a worksheet in a VSTO Add-in.

• The worksheet that you want to hide was created at run time in a document-level customization.

1. Set the Visible property of the worksheet to the xlSheetHidden enumeration value.

   • C#
   • VB

   ((Excel.Worksheet) Globals.ThisWorkbook.Sheets[1])
       .Visible = Excel.XlSheetVisibility.xlSheetHidden;
   

• Work with worksheets
• How to: Programmatically delete worksheets from workbooks
• How to: Programmatically move worksheets Within workbooks
• How to: Programmatically protect worksheets
• Host items and host controls overview
• Global access to objects in Office projects