Notes in secured excel worksheet

Occasional Visitor

I have a worksheet in which I can add 'remarks' and 'notes'.

If I protect the worksheet I can only use the option 'add remark'  and the possibilty of 'add note' is disappeared.

When I take off the protection the possibility 'add note' appears again.

In the spreadsheet I have several protected worksheets and in some this happens in other protected worksheet I can use 'add note' without any problem.

 

Please give me the solution.

 

 

1 Reply

Hi @Peter_1000,

 

When you are protecting your sheet, it should give you a list of things you can allow users to do while it is protected. If you have "Edit objects" selected, people should be able to add both notes and comments to the sheet. Let me know if that answers your question.

 

Corder_0-1657643444681.png