Inserting a comment box in a protected worksheet

M

mskpr1

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?
 
L

Luke M

(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.
 
L

Luke M

(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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enabling Autofilter and Sorting in a Protected Sheet 2
Entering photos or pdf into a protected sheet 1
How can I have a protected worksheet and have spell check ability 1
corrupted formula in protected worksheet 21
Data copy locks cell in worksheet 3
Hyperlinks on Protected worksheet 1
Allow Insert Rows in a protected worksheet 2
Inserting Picture Into Protected Worksheet 1

Top