Inserting Comment Problem

C

Chris

I have protected a few cells in a worksheet. There is a
need to add and edit comments to the unprotected cells.
However, when you select an unprotected cell and go to
insert comment the insert comment is greyed out.
 
F

Frank Kabel

Hi
depending on your Excel version you can enable comment insertions in
the protection dialog (check 'Objects' for this)
 
D

David McRitchie

Hi Chris,
When you protect your worksheet, uncheck protect objects.
Then all comments are open to change.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top