Comment in protected sheet

  • Thread starter Thread starter jamalhakem
  • Start date Start date
J

jamalhakem

Hi
Any help
How can I give permission to other users to add comment to my protected sheet
Thanks in advance
Jam
 
It happens that (e-mail address removed) formulated :
Hi
Any help
How can I give permission to other users to add comment to my protected sheet
Thanks in advance
Jam
Click to expand...

Unlock any cells where you want users to enter comments, OR provide
unlocked cells for them to use for that purpose!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
When protecting the sheet allow users to "edit objects"

Does not matter if the cells are locked or unlocked, as long as you
can select them.


Gord
 
Gord Dibben submitted this idea :
Don't need unlocked cells if you allow users to "edit objects".

Gord
Click to expand...

Well, you're absolutely right but I wasn't thinking of 'Cell Comments'
though. I was thinking the OP was asking about using cells to enter
comments instead, being that sheet protection allows editing objects!
In this case I presumed using cells for this since sheet protection was
already configured (or so I ass-u-me d).<g>

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
Back
Top