Comment in protected sheet
 

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

Comment in protected sheet
 

It happens that formulated :
Hi
Any help
How can I give permission to other users to add comment to my protected sheet
Thanks in advance
Jam

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

Comment in protected sheet
 

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

On Mon, 11 Jun 2012 14:15:23 -0700 (PDT), wrote:

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

Comment in protected sheet
 

Don't need unlocked cells if you allow users to "edit objects".

Gord

On Mon, 11 Jun 2012 17:31:46 -0400, GS wrote:

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

--
Garry

Comment in protected sheet
 

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

Gord

On Mon, 11 Jun 2012 17:31:46 -0400, GS wrote:

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

--
Garry

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

Comment in protected sheet
 

We'll have to wait for a response from OP<g


Gord

On Tue, 12 Jun 2012 00:17:06 -0400, GS wrote:

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

Gord

On Mon, 11 Jun 2012 17:31:46 -0400, GS wrote:

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

--
Garry

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

Comment in protected sheet
 

Gord Dibben wrote :
We'll have to wait for a response from OP<g

Did you mean "we'll have to *see* if we get a response..."?<bg

--
Garry

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