ID: Q177535
The information in this article applies to:
In Microsoft Excel for the Macintosh, if you double-click the title bar of a workbook window, or if you click the collapse box in the upper-right corner of a workbook window, the workbook window collapses into the title bar. This behavior occurs even if you protect the workbook by pointing to Protection on the Tools menu and clicking Protect Workbook.
This behavior occurs because the WindowShade feature (Collapsing Windows in Mac OS 8.0) that is available on a Macintosh computer affects all windows, including windows of protected workbooks.
You cannot prevent this feature from affecting protected workbooks. To resolve this behavior, save your work, quit any running programs, and then disable the feature. In Mac OS 8.0 (System 8.0), click Control Panel on the Apple menu, double-click Appearance, and then clear the "Double-click title bar to collapse" check box. In earlier versions of the system software, use the Extensions Manager to disable the WindowShade extension, and then restart the computer.
Note that although you can collapse the window of a protected workbook, you cannot resize, move, hide, or close the window.
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
In Microsoft Excel, you can protect a workbook by following these steps:
1. Point to Protection on the Tools menu, and then click Protect Workbook.
2. To protect the structure of the workbook, click to select the Structure
check box.
This step prevents sheets from being moved, hidden, unhidden, renamed,
added, or deleted.
To protect the workbook windows, click to select the Window check box.
This prevents the windows from being moved, resized, hidden, unhidden,
or closed.
Although the workbook window may be protected, protecting the workbook does not affect the operation of the WindowShade feature because collapsing a window does not affect the window's position or size.
Additional query words: XL5
Keywords : kbenv kbui xlui
Version : MACINTOSH:5.0,5.0a
Platform : MACINTOSH
Issue type : kbprbLast Reviewed: February 9, 1998