Comments in Excel

[Guest]

I do schedules in Excel and post it on a shared drive. I lock the book for
read only. I insert comments in some of the cells for my own information ie.
(used all his/her sick leave this year). I want people to see the schedule
but I dont want them to be able to see the comments. I know about the
tool/options/None in comments so they are not visible but any users can
change that setting and view the comments. Is there any way the comments can
be locked?

 

[Mark Lincoln]

How about putting comments in a Notes column at the end of your data?
Hide the column and protect the sheet with a password. That may work
for you.

 

[Guest]

Thank-you Mark, Great tip