A
AccessHelp
I insert a comment in one of the locked cells. If I protect the sheet
without the Edit Objects box checked and when I point to that cell, the
comment won't show.
On the other hand, if I protect the sheet with the Edit Objects box checked,
the comment will show; however, it will also allow the user to make changes
to the comment.
My sheet contains multiple columns, and the column headers are protected. I
am inserting comments in the column headers so that the users know the
purpose of those columns and what to enter. I like it to be able to show
when the user points to the header, and I don't like the users able to change
the comments.
Is there a way to do it?
Thanks.
Alan
without the Edit Objects box checked and when I point to that cell, the
comment won't show.
On the other hand, if I protect the sheet with the Edit Objects box checked,
the comment will show; however, it will also allow the user to make changes
to the comment.
My sheet contains multiple columns, and the column headers are protected. I
am inserting comments in the column headers so that the users know the
purpose of those columns and what to enter. I like it to be able to show
when the user points to the header, and I don't like the users able to change
the comments.
Is there a way to do it?
Thanks.
Alan