Protection

G

Gene

I have a spreadsheet with a mixture of locked and unlocked cells
Comments can be added to the unlocked cells when the worksheet i
unprotected but this ability is not available when the worksheet i
protected. Is there a way to protect a spreadsheet and still retai
the ability to add comments to unlocked cells
 
C

Chip Pearson

What version of Excel are you using? In Excel 2002 (I think) and
later, you can choose "Edit Objects" in the list of allowable
actions display when you choose 'Protection' from the Tools menu.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


in message
news:[email protected]...
 
Top