Prevent Comments being added to unlocked cell in protected sheet - Excel 365

[SaraWitch]

Good afternoon all,

I'm using Excel 365, and I wonder if anyone knows if there's a way to prevent Comments being added to an unlocked cell in a protected sheet? When protecting the sheet, I have unticked 'Edit Objects' and this prevents Notes being added, but users are still able to add a Comment, which I don't want!

Also, I want users to be able to insert, cut and insert copied rows. Whilst I have 'Insert rows' and 'Delete rows' ticked when protecting the sheet, I am unable to do this. Any ideas please?

Ta muchly, folks!
Sara

 

[Fluff]

@Logit The OP is talking about the New Comments (Comments Threaded), not the old Comments (which are now called Notes).
Thanks to MS for making things as confusing as possible.

 

[SaraWitch]

Thank you @Fluff - thought I had unprotected the whole row, but I couldn't have done because insert, etc., row now working!

And thank you @Logit for your time. The code isn't working for me, but I do now notice that when closing the workbook there's a prompt that asks if you want to return to the comment to post it. If you don't, it's discarded, and if you do, and post, it disappears (I think! I certainly can't find comments after they've been posted!).

I agree @Fluff, thanks MS for these changes!!

 

[Fluff]

Glad we could help & thanks for the feedback.