Prevent comments from being deleted in Excel

Copper Contributor

Is there a way to prevent comments from being deleted?  Or better yet, assign permissions in the sheet so that only a certain person/s could delete comments?

 

Thanks!

2 Replies

Ensure that cells containing comments are locked, and then protect the sheet. This way, your comments remain uneditable.

@SanthoshKunder  I tried that but the users are still able to delete comments and it doesnt show the comments added or deleted in the review changes section either.