Sheet protection "protecting" too much!


P

Patrick

I have protected a worksheet but have allowed others to make needed entries
in certain areas. One such area is where they have to put an "X" in the cell
which they are allowed to do. However, they also need the ability to put a
comment in the cell which they are not allowed to do. What do I need to do
to get themm access to the "insert comment" option?

Thank you!
 
Ad

Advertisements

P

Patrick

Thanks, Paul. That did the trick. You were right about them being able to
insert comments in other otherwise locked cells, but since they would have no
need to do so I am hoping that won't be a problem. Thanks again!
 
G

Gord Dibben

When you protect the sheet uncheck the "allow users to select locked cells"

If you can't select, you can't insert a comment.


Gord Dibben MS Excel MVP
 
Ad

Advertisements

P

PCLIVE

Oh stupid me, Gord. I knew that. What was I thinking?
Thanks for clearing that up.

Paul

--
 

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