![]() |
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 |
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 |
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 |
All times are GMT +1. The time now is 09:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com