Inserting Comments into Cells of Protected Worksheet

S

Steve

I have a worksheet that is password protected but allows users to add values
in certain cells. I can input information in the cells but when I want to
add a comment in the same cells, it is greyed out. When I unprotect the
sheet, I can add comments. I do not want to unprotect the sheet to the
users. Any suggestions?
 
G

Gord Dibben

Excel 2002 and 2003 versions and probably 2007
version............Tools>Protection>Protect Sheet. Checkmark in "Edit Objects"


Gord Dibben MS Excel MVP
 
Top