Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protected worksheet with unprotected cells i.c.w. remarks
I have a worksheet, which is protected. On the sheet there are several
unprotected cells. Other user should have the possibilty to add remarks at the unprotected cells. But, although the cells are unprotected, it seems not possible for them to add remarks. The option is light grey (=inaccassible). Is there another solution to this? I don't want to give them my password for the sheet. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protected worksheet with unprotected cells i.c.w. remarks
I think when you protect it, you can uncheck the box for objects and this
will enable the users to insert comments (into both locked and unlocked cells). There may, however, be other objects on your worksheet that you don't want to allow access to, so you should play with it a little and see this will allow access to other things you don't want the user's to have access to. "FrankOtter68" wrote: I have a worksheet, which is protected. On the sheet there are several unprotected cells. Other user should have the possibilty to add remarks at the unprotected cells. But, although the cells are unprotected, it seems not possible for them to add remarks. The option is light grey (=inaccassible). Is there another solution to this? I don't want to give them my password for the sheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i format inserted cells in protected worksheet? | Excel Worksheet Functions | |||
adding comments to unprotected cell/range in protected worksheet | Excel Worksheet Functions | |||
How can I use open/close Grouped cells in a Protected Worksheet? | Excel Discussion (Misc queries) | |||
Move cursor through all unprotected cells in a protected worksheet | Excel Discussion (Misc queries) | |||
Unprotecting Cells in a Protected Worksheet | Excel Discussion (Misc queries) |