Microsoft KB Archive/122416

= 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.