Comments to protected sheet

[Guest]

How do I add comments to an unprotected cell in a protected sheet ?

 

[Frank Kabel]

Hi
which Excel version are you using?
in Excel 2003 you can do the following:
- goto 'Tools - Protection - Sheet'
- check 'edit object' in the dialog

This allows the entry of comments for unlocked cells

 

[Debra Dalgleish]

If you allow users to edit objects, they'll be able to insert a comment
in any cell in the protected sheet.