Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Comments in protected worksheets
Thanks for reading this post.
I am using Office 2003. I have a protected worksheet with many un-locked cells where data would be entered. At times I also want to insert comments in these cells (ie.in un-locked cells) describing the data entered in the cell. Though Excel 2003 allows certain flexibility but not insert comments, is there a way this could be achieved? Preman |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Comments in protected worksheets
When you protect the sheet, allow the users to "edit objects" at the bottom of
that list. But this allows other objects to be added/deleted/moved.... jpreman wrote: Thanks for reading this post. I am using Office 2003. I have a protected worksheet with many un-locked cells where data would be entered. At times I also want to insert comments in these cells (ie.in un-locked cells) describing the data entered in the cell. Though Excel 2003 allows certain flexibility but not insert comments, is there a way this could be achieved? Preman -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Comments in protected worksheets
Thank you Dave for your response.
It works fine. I am sorry for the delayed feedback. Regards "Dave Peterson" wrote: When you protect the sheet, allow the users to "edit objects" at the bottom of that list. But this allows other objects to be added/deleted/moved.... jpreman wrote: Thanks for reading this post. I am using Office 2003. I have a protected worksheet with many un-locked cells where data would be entered. At times I also want to insert comments in these cells (ie.in un-locked cells) describing the data entered in the cell. Though Excel 2003 allows certain flexibility but not insert comments, is there a way this could be achieved? Preman -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting Pictures to Protected Worksheets | Excel Discussion (Misc queries) | |||
Protected worksheets | Excel Discussion (Misc queries) | |||
Using Collapse/Expand with Protected worksheets | Excel Discussion (Misc queries) | |||
Comments & protected sheets | Excel Discussion (Misc queries) | |||
Inserting comments on graphs | Excel Discussion (Misc queries) |