Partager via


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

  • 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

Concepts

Working with Worksheets

Host Items and Host Controls Overview

Global Access to Objects in Office Projects