Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL2000: Can't Hide/Unhide Sheets If Workbook Contents Protected


View products that this article applies to.

This article was previously published under Q214299

↑ Back to the top


Symptoms

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.

↑ Back to the top


Cause

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.

↑ Back to the top


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.

↑ Back to the top


References

For more information about protecting workbooks, click Microsoft Excel Help on the Help menu, type protect workbooks from changes in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top


Keywords: KB214299, kbprb, kbconversion

↑ Back to the top

Article Info
Article ID : 214299
Revision : 3
Created on : 10/6/2003
Published on : 10/6/2003
Exists online : False
Views : 242