Can't Hide/Unhide Sheets If Workbook Contents Protected

Article translations Article translations
Article ID: 108033 - View products that this article applies to.
This article was previously published under Q108033
Expand all | Collapse all

SYMPTOMS

In the Microsoft Excel versions listed at the beginning of this article, you cannot hide or unhide sheets in a workbook that has been saved with a protected workbook contents window in Microsoft Excel version 4.0.

CAUSE

In the Microsoft Excel versions listed at the beginning of this article, you cannot hide or unhide sheets in a workbook when the workbook structure has been protected. When you protect the workbook contents window in Microsoft Excel version 4.0, you can then hide and unhide sheets in the workbook individually. However, when you open the workbook in versions of Microsoft Excel later than 4.0, the workbook structure is protected and you cannot hide or unhide individual sheets in the workbook.

MORE INFORMATION

Workbooks in Microsoft Excel version 4.0 do not have an option to protect the workbook structure, only the workbook window. In versions later than 4.0, with the protection set to window and not structure, the sheet can be hidden. However, protecting the workbook structure disables the hide option for that worksheet.

To protect the structure of a workbook in versions of Microsoft Excel later 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 Unprotect Workbook commands (Tools Menu), click the Search button in Help and type:

   protecting workbooks
				

Properties

Article ID: 108033 - Last Review: August 15, 2003 - Revision: 1.1
APPLIES TO
  • Microsoft Excel 97 Standard Edition
Keywords: 
kbconversion kbprb KB108033
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.

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com