Can't Hide/Unhide Sheets If Workbook Contents Protected

This article was previously published under Q108033
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
SYMPTOMS
In the Microsoft Excel versions listed at the beginning of thisarticle, you cannot hide or unhide sheets in a workbook that has beensaved with a protected workbook contents window in Microsoft Excelversion 4.0.
CAUSE
In the Microsoft Excel versions listed at the beginning of thisarticle, you cannot hide or unhide sheets in a workbook when theworkbook structure has been protected. When you protect the workbookcontents window in Microsoft Excel version 4.0, you can then hide andunhide sheets in the workbook individually. However, when you open theworkbook in versions of Microsoft Excel later than 4.0, the workbookstructure is protected and you cannot hide or unhide individual sheetsin the workbook.
MORE INFORMATION
Workbooks in Microsoft Excel version 4.0 do not have an option toprotect the workbook structure, only the workbook window. In versionslater than 4.0, with the protection set to window and not structure,the sheet can be hidden. However, protecting the workbook structuredisables the hide option for that worksheet.

To protect the structure of a workbook in versions of Microsoft Excellater than 4.0, follow these steps:

  1. On the Tools menu, point to Protection and then click Protect Workbook.
  2. Click to select the Structure check box, and click OK.

REFERENCES
For more information about the Protect Workbook Command and UnprotectWorkbook commands (Tools Menu), click the Search button in Help andtype:

   protecting workbooks				
5.00 7.00 8.00 97 XL97 XL7 XL5 XL
Properties

Article ID: 108033 - Last Review: 08/15/2003 15:13:50 - Revision: 1.1

Microsoft Excel 97 Standard Edition

  • kbconversion kbprb KB108033
Feedback