ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protected worksheet and comments (https://www.excelbanter.com/excel-discussion-misc-queries/67543-protected-worksheet-comments.html)

Jack

Protected worksheet and comments
 
Hi
How can I enter/edit/delet comments in a protected worksheet.
I made a worksheet and left the normal workcells unlocked. When the sheet is
password protected I can enter data but no comments.
What I have to do in order to solve this problem?

Thanks

Paul B

Protected worksheet and comments
 
Jack, depends on what version of excel you have, when you protect the sheet
see if you have and option to allow users to edit objects, if so check that
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Jack" wrote in message
...
Hi
How can I enter/edit/delet comments in a protected worksheet.
I made a worksheet and left the normal workcells unlocked. When the sheet
is
password protected I can enter data but no comments.
What I have to do in order to solve this problem?

Thanks





All times are GMT +1. The time now is 10:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com