Comment in protected sheet

J

jamalhakem

Hi
Any help
How can I give permission to other users to add comment to my protected sheet
Thanks in advance
Jam
 
G

GS

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
 
G

Gord Dibben

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
 
G

GS

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
 

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

Add comment in protected worksheet 3
Inserting Comments into Cells of Protected Worksheet 1
How do I add comments to a protected sheet? 1
comment 1
List 3
Protected cells can't be grouped 1
group/ungroup protected sheets? 3
edit a comment while protect sheet is on the cell is unprotected 1

Top