Thread: Inserting Comments into Cells of Protected Worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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?

Reply With QuoteReply With Quote