|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 11th 12, 10:15 PM
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 
|
| Ads |
|
#2
June 11th 12, 10:31 PM
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
June 12th 12, 04:18 AM
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
|
|
#4
June 12th 12, 04:19 AM
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
|
|
#5
June 12th 12, 05:17 AM
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
|
|
#6
June 12th 12, 03:00 PM
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>
|
|
#7
June 12th 12, 05:59 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Inserting a Comment in a Protected Sheet? | jcolley05 | Excel Discussion (Misc queries) | 1 | May 1st 07 04:35 PM |
| Inserting comment in unlocked cell in protected sheet | DevoGuy | Excel Programming | 0 | March 7th 07 05:02 PM |
| Add comment in a protected sheet, Excel 2000 | Mats Nilsson | Excel Programming | 4 | October 6th 06 07:16 PM |
| How do I create a comment on an unlocked cell in a protected sheet | LObeidat | Excel Discussion (Misc queries) | 1 | July 25th 06 01:14 PM |
| Adding a Comment on a protected sheet | Sean | Excel Programming | 3 | July 18th 06 06:55 PM |
Linear Mode
