Enter comments in a protected Excel worksheet

G

Guest

How do I enter comments into a protected worksheet? I just want comments in
one column on the worksheet, but it doesn't appear to be enabled unless I
take the protection off which I don't want to do.
 
G

Guest

Sue,

When you protect a worksheet you are asked to check / uncheck 3 boxes
(contents, objects, scenarios). The objects box is the one that controls
whether you can enter comments or not. Therefore, if when you protect the
worksheet you UNCHECK the objects box you should be able to enter comments.
Play around with the different scenarios of checking / unchecking certain
boxes to see if it meets your needs. There is no way that I know of to enter
comments on a protected worksheet when the objects box is checked.

Hope this helps.

Thanks,
Bill Horton
 

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

Inserting comment in unlocked cell of protected Excel worksheet? 1
Inserting Comments into Cells of Protected Worksheet 1
Protected worksheet/tab key 2
Protected Workbook, no comments? 1
Can't Edit Worksheet Comments 1
Tabbing on a Protected worksheet 3
How can I use spell checking in a protected worksheet? 1
Copying cells in a protected worksheet 2

Top