| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I add a "Comment" to an unlocked cell in a protect worksheet
One of our operatives would like to add comments to onlocked cells within a
protected spreadsheet is this possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I add a "Comment" to an unlocked cell in a protect worksheet
Yes if you have Excel 2002 or newer.
ToolsProtectionProtect WorksheetAllow users to: Checkmark "edit objects" That will allow users to enter Comments in any cell, not just unlocked cells, so best to disallow "select locked cells" also. Gord Dibben MS Excel MVP On Fri, 16 Jan 2009 15:29:01 -0800, bjb wrote: One of our operatives would like to add comments to onlocked cells within a protected spreadsheet is this possible? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I add a "Comment" to an unlocked cell in a protect worksheet
xl2k (and before) has 3 options on that protection dialog.
One of them does the same as as the "edit objects"--maybe it's even named the same???? Gord Dibben wrote: Yes if you have Excel 2002 or newer. ToolsProtectionProtect WorksheetAllow users to: Checkmark "edit objects" That will allow users to enter Comments in any cell, not just unlocked cells, so best to disallow "select locked cells" also. Gord Dibben MS Excel MVP On Fri, 16 Jan 2009 15:29:01 -0800, bjb wrote: One of our operatives would like to add comments to onlocked cells within a protected spreadsheet is this possible? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I add a "Comment" to an unlocked cell in a protect worksheet
Thanks Dave.
Can't remember that far back. Gord On Fri, 16 Jan 2009 19:50:56 -0600, Dave Peterson wrote: xl2k (and before) has 3 options on that protection dialog. One of them does the same as as the "edit objects"--maybe it's even named the same???? Gord Dibben wrote: Yes if you have Excel 2002 or newer. ToolsProtectionProtect WorksheetAllow users to: Checkmark "edit objects" That will allow users to enter Comments in any cell, not just unlocked cells, so best to disallow "select locked cells" also. Gord Dibben MS Excel MVP On Fri, 16 Jan 2009 15:29:01 -0800, bjb wrote: One of our operatives would like to add comments to onlocked cells within a protected spreadsheet is this possible? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I add a "Comment" to an unlocked cell in a protect worksheet
Ps. But xl2k and before doesn't have that option (in the user interface) to
prevent the user from selecting locked cells. Gord Dibben wrote: Yes if you have Excel 2002 or newer. ToolsProtectionProtect WorksheetAllow users to: Checkmark "edit objects" That will allow users to enter Comments in any cell, not just unlocked cells, so best to disallow "select locked cells" also. Gord Dibben MS Excel MVP On Fri, 16 Jan 2009 15:29:01 -0800, bjb wrote: One of our operatives would like to add comments to onlocked cells within a protected spreadsheet is this possible? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert cell "contents" into a "comment" | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| How to change text color in a cell "comment" in Office 2007? | Excel Worksheet Functions | |||
| How can I use a filter and still use "protect worksheet"? | Excel Worksheet Functions | |||
| How to override "Too Many Cell Formats" error comment. | New Users to Excel | |||
Hybrid Mode
