Insert Comment into Protected Sheet

J

Jeff Mackeny

If I protect my sheet, I'm unable to add comments to any cell, even I
uncheck 'Locked' from that cell.
 
F

Frank Kabel

Hi Jeff
in Excell 2002+ you also have to check 'Edit/Insert Objects' in the
protection dialog
 
J

Jeff Etcell

Jeff,

If using Excel 2000 you can uncheck the Objects box when
protecting your worksheet.

This still protects the contents of the Locked cells but
enables you to change any comments
 
Top