Comments in Excel

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?

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.

Thank-you Mark, Great tip

"Mark Lincoln" wrote:

> 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.
>
>