Forum Discussion

Peter_1000's avatar
Peter_1000
Copper Contributor
Jul 12, 2022

Notes in secured excel worksheet

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.

 

 

  • Corder's avatar
    Corder
    Copper Contributor

    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.

     

     

Resources