Microsoft Knowledge Base

XL: Cannot Use Cell Note Tool on Protected Sheet
Last reviewed: September 13, 1996
Article ID: Q122416
The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SYMPTOMS

When you attempt to use the Attach Note tool on a protected worksheet, you will receive the following error message: 

   Cannot use that command on a protected sheet

WORKAROUNDS

To work around this problem, follow the appropriate procedure below.

If objects in the sheet do not need to be protected

  • When you protect the sheet, clear the Objects check box in the Protect Sheet dialog box. This will allow you to use the Attach Note tool to access notes in cells.

If objects in the sheet must be protected

To access notes in cells when you are working in a protected sheet and the objects ARE protected, do either of the following:

  • From the Insert menu, choose Note.

    -or-

  • Press SHIFT+F2.

REFERENCES

"User's Guide," version 5.0, Pages 675-677

KBCategory: kbusage
KBSubcategory:

Additional reference words: 5.00 7.00



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: September 13, 1996
©1997 Microsoft Corporation. All rights reserved. Legal Notices.