|Important||This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer|
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.
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
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.