The information in this article applies to:
SYMPTOMSIn 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. CAUSEIn 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.
REFERENCES
For more information about the Protect Workbook Command and Unprotect
Workbook commands (Tools Menu), click the Search button in Help and
type:
Additional query words: 5.00 7.00 8.00 97 XL97 XL7 XL5
Keywords : kbdta kbconversion xlui |
Last Reviewed: April 9, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |