Insert Comments on a Protected Worksheet

  • Thread starter Thread starter cinnie
  • Start date Start date
C

cinnie

hi - I have a worksheet with areas that are locked, and a range B5:H23 that
is not locked. Protection has been applied to the sheet. The user is
allowed to SELECT unlocked cells.

My problem is that I want to be able to INSERT COMMENTS in the unlocked
range. I can't seem to do this while protection is ON. (Comments can only
be added when Protection is OFF) What am I missing?

thanks in advance
 
When setting sheet protection allow users to "Edit Objects"........down near
bottom of list.

Then you can Insert Comments in unlocked cells.


Gord Dibben MS Excel MVP
 
Back
Top