Sheet protection "protecting" too much!

[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!

 

[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!

 

[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

 

[PCLIVE]

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

Paul

--