ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Inserting Comments in protected worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/99037-inserting-comments-protected-worksheets.html)

jpreman

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



Dave Peterson

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

jpreman

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