SOLVED

How to add notes to a protected worksheet?

Copper Contributor

I have a worksheet with partly unblocked cells to enter data and blocked cells to prevent changing of formulas.

After protecting the sheet I would like to add notes to the cells that are unblocked, however the note function is not available anymore.

 

 

 

2 Replies
best response confirmed by PaulO1949 (Copper Contributor)
Solution

@PaulO1949 

When you protect the sheet, tick the check box "Edit objects".

If you don't want to allow comments in locked cells, clear the check box "Select locked cells".

S0918.png

@Hans Vogelaar 

 

Thanks for this quick answer!

It works now the way I want it to.

1 best response

Accepted Solutions
best response confirmed by PaulO1949 (Copper Contributor)
Solution

@PaulO1949 

When you protect the sheet, tick the check box "Edit objects".

If you don't want to allow comments in locked cells, clear the check box "Select locked cells".

S0918.png

View solution in original post