| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding comments into a protected worksheet | Excel Discussion (Misc queries) | |||
| INSERTING ROWS IN PROTECTED WORKSHEET | Excel Discussion (Misc queries) | |||
| Inserting Comments in protected worksheets | Excel Discussion (Misc queries) | |||
| Inserting Comments into Protected sheet | Excel Discussion (Misc queries) | |||
| Protected worksheet and comments | Excel Discussion (Misc queries) | |||
Linear Mode
