Allow comments to be added to protected worksheet? - Excel 2007

  • Thread starter Thread starter sue@solotel
  • Start date Start date
S

sue@solotel

I have created a worsksheet with selected areas locked and then protected it.
My users want to be able to add comments where necessary but are not able to.
I cant seem to find anything in the help menu - any ideas?
 
When protecting the sheet "allow users to:"

Select unlocked cells and Edit Objects.

Note: with edit objects checked, users can insert comments in locked cells
if they are allowed to select those.


Gord Dibben MS Excel MVP
 
Back
Top