| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting a comment box in a protected worksheet
I have a worksheet that is shared by others and is protected. The shared
users are only allowed to enter data into certain cells. But I would like them to be able to insert a comment box on the unlocked cells. Is there a way this can be done without unprotecting the worksheet? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting a comment box in a protected worksheet
(not exact solution)
If when protecting the workbook, you allow users to Edit Objects, they will be able to comment on cells. Unfortunately, they will be able to comment on all cells, not just the unlocked ones. Depending on if this is a major concern, it might help. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "mskpr1" wrote: I have a worksheet that is shared by others and is protected. The shared users are only allowed to enter data into certain cells. But I would like them to be able to insert a comment box on the unlocked cells. Is there a way this can be done without unprotecting the worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting comment in unlocked cell of protected Excel worksheet? | Excel Worksheet Functions | |||
| Inserting a Comment in a Protected Sheet? | Excel Discussion (Misc queries) | |||
| can you insert a comment into a protected worksheet? | Excel Worksheet Functions | |||
| How do I insert a comment in a protected worksheet ? | Excel Discussion (Misc queries) | |||
| Insert comment in protected worksheet | Excel Worksheet Functions | |||
Linear Mode
