Nov 23 2021 03:01 AM
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.
Nov 23 2021 03:32 AM
SolutionWhen 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".
Nov 23 2021 03:28 PM
Nov 23 2021 03:32 AM
SolutionWhen 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".