Enabling comments on a protected worksheet

  • Thread starter Thread starter S Phadke
  • Start date Start date
S

S Phadke

I have a protected worksheet, where I want the user to be
able to add comments on certain cells. Is it possible to
enable comments on a protected worksheet?

Sam
 
Posted By Norman Harker

In Excel 2002 you can use:

Tools > Protection > Protect Sheet
Put check against Edit Objects

That allows users to both insert comments and edit them.


In Excel 1997 and 2000 you can use:

Tools > Protection > Protect Sheet
Remove check from Objects

That allows users to both insert comments and edit them.
 
Back
Top