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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|