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

SaraWitch

Board Regular
Joined
Sep 29, 2015
Messages
102
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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
:)
 
Last edited:

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,467
Office Version
  1. 365
Platform
  1. Windows
@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.
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

SaraWitch

Board Regular
Joined
Sep 29, 2015
Messages
102
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,467
Office Version
  1. 365
Platform
  1. Windows
Glad we could help & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,356
Messages
5,635,791
Members
416,882
Latest member
ericvrealty

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top