Forum Discussion
Solved
How to add notes to a protected worksheet?
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.
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".
2 Replies
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".
