XL: Protected Workbook Windows Can Be Collapsed

Last reviewed: February 5, 1998
Article ID: Q177535
The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a
  • Microsoft Excel 98 Macintosh Edition

SYMPTOMS

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.

CAUSE

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.

RESOLUTION

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.

STATUS

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.

MORE INFORMATION

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.

  3. When you are done, click OK.

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 : xlui kbenv kbui
Version : MACINTOSH:5.0,5.0a
Platform : MACINTOSH
Issue type : kbprb


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 5, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.