Insert Comment

B

Bernard

Hi All,
I have cells F1-F31 for daily expenses. Some expenses need to be explained,
thus Insert Comment is used.
My dilemma is if I unlock the column and protect the sheet, Insert Comment
will be grayed out.
For every comment I have to unprotect the sheet, Insert Comment, protect the
sheet.
I am sure there is a simpler way.
Thanks for your input.

Regards,
Bernard
 
G

Gord Dibben

Bernard

When you protect the sheet you can choose to "Edit Objects"

This will allow you to insert comments on those unlocked cells.

Note: you must be running 2002 or newer.


Gord Dibben MS Excel MVP
 

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

Similar Threads


Top