| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a Comment in a Protected Sheet? | Excel Discussion (Misc queries) | |||
| Inserting comment in unlocked cell in protected sheet | Excel Programming | |||
| Add comment in a protected sheet, Excel 2000 | Excel Programming | |||
| How do I create a comment on an unlocked cell in a protected sheet | Excel Discussion (Misc queries) | |||
| Adding a Comment on a protected sheet | Excel Programming | |||
Hybrid Mode
