Inserting Comments into Cells of Protected Worksheet
 

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?

Inserting Comments into Cells of Protected Worksheet
 

Excel 2002 and 2003 versions and probably 2007
version............ToolsProtectionProtect Sheet. Checkmark in "Edit Objects"


Gord Dibben MS Excel MVP

On Thu, 29 Mar 2007 12:20:02 -0700, Steve
wrote:

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?