Comments

[LPhillips]

Can you tell me how to add comments to an individual cell when the worksheet
is protected? The option does not appear on the toolbar nor when right
clicking.

 

[Pierre]

Can you tell me how to add comments to an individual cell when the worksheet
is protected? The option does not appear on the toolbar nor when right
clicking.

This might help you.
from:
http://www.mrexcel.com/forum/showthread.php?t=63962

"In other versions, if you protect the sheet, but uncheck the objects
box, this will allow for comments to be inserted"

Let us know the results.


Pierre

 

[Gord Dibben]

Tools>Protection>Protect Sheet>Allow users to:

Make sure "Edit Objects" is checkmarked.


Gord Dibben MS Excel MVP