| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to add cell comments in unlocked cell on protected worksheet
Using Excel 2002, I have a worksheet that I have "protected" so that only a
certain block of cells can be selected/edited. Today, I have a new requirement to be able to add/edit/delete cell comments on those cells that remain unlocked. But the options to do so on the cell context menu disappear when the worksheet is protected, but reappear when the worksheet is unprotected. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to add cell comments in unlocked cell on protected worksheet
When you protect the worksheet, scroll down and check "edit objects".
This will allow comments to be added/removed/changed--along with other objects (pictures/shapes/etc). dan400man wrote: Using Excel 2002, I have a worksheet that I have "protected" so that only a certain block of cells can be selected/edited. Today, I have a new requirement to be able to add/edit/delete cell comments on those cells that remain unlocked. But the options to do so on the cell context menu disappear when the worksheet is protected, but reappear when the worksheet is unprotected. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to add cell comments in unlocked cell on protected worksh
Commit to memory: Cell comments are "objects".
Too bad Excel (non-)Help had nothing on the topic. Thanks for the quick response Dave! "Dave Peterson" wrote: When you protect the worksheet, scroll down and check "edit objects". This will allow comments to be added/removed/changed--along with other objects (pictures/shapes/etc). dan400man wrote: Using Excel 2002, I have a worksheet that I have "protected" so that only a certain block of cells can be selected/edited. Today, I have a new requirement to be able to add/edit/delete cell comments on those cells that remain unlocked. But the options to do so on the cell context menu disappear when the worksheet is protected, but reappear when the worksheet is unprotected. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to add cell comments in unlocked cell on protected worksheet
Since you're using 2002 you can set this up when protecting the sheet.
ToolsProtectionProtect Sheet Uncheck "select locked cells" and check "select unlocked cells" and check "edit objects" Gord Dibben Excel MVP On Fri, 16 Dec 2005 09:55:04 -0800, dan400man wrote: Using Excel 2002, I have a worksheet that I have "protected" so that only a certain block of cells can be selected/edited. Today, I have a new requirement to be able to add/edit/delete cell comments on those cells that remain unlocked. But the options to do so on the cell context menu disappear when the worksheet is protected, but reappear when the worksheet is unprotected. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace within Unlocked Cells in a Protected Worksheet | Excel Discussion (Misc queries) | |||
| hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions | |||
| Data From One Worksheet To Be Used In A Cell In A Different Worksheet | Excel Worksheet Functions | |||
| How can I activate cell shading in a protected worksheet? | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
