SOLVED

How to add notes to a protected worksheet?

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