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)


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


@Hans Vogelaar 


Thanks for this quick answer!

It works now the way I want it to.