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 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.

To hide a worksheet using a worksheet host item

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

                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 an VSTO 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

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

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

Working 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

Show: