ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Inserting a comment box in a protected worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/230832-inserting-comment-box-protected-worksheet.html)

mskpr1

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?

Luke M

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?



All times are GMT +1. The time now is 02:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com