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.
 

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

Adding a comment in a footnote area 1
No text box in word 2016 0
Outlook mail shared questions 0
Enabling Autofilter and Sorting in a Protected Sheet 2
Unclear change tracking process 0
Can't insert row in data table in protected worksheet 0
Managing multiple jobs in a fabrication shop 0
Sharing workbooks limitations - Merged Cells 12

Top