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

I just tried this in xl2003.

I added a comment to a cell.
I protected the worksheet (just "select locked cells" and "select unlocked
cells" were checked).

The comment showed up when I moused over that cell with the comment.

(I had "Comment indicator only" checked in tools|Options|view tab.)

If you try it again and it fails, you may want to post back with more
info--including the version of excel and that setting.

AccessHelp wrote:

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

--

Dave Peterson

Hi Dave,

Thanks for your help. I am also using Excel 2003, and I do have the
"Comment Indicator Only" selected.

When I protect the sheet, in addition to the two items that you mentioned, I
also have the following boxes checked: "Format columns", "Format rows",
"Insert rows" and "Use AutoFilter". I have those checked so that the users
can hide, insert and expand the rows and columns and use the filter.

In addition to those items, again, if I have the Edit objects box checked,
not only the comment would show, you can even edit it. If I don't have it
checked, the comment would not show at all, but you can see the comment
indicator in the cell. When I move the mouse over to the cell, it turns into
a hand pointer.

In the Format Comment, both lock boxes are checked.

Thanks again.

"Dave Peterson" wrote:

I just tried this in xl2003.

I added a comment to a cell.
I protected the worksheet (just "select locked cells" and "select unlocked
cells" were checked).

The comment showed up when I moused over that cell with the comment.

(I had "Comment indicator only" checked in tools|Options|view tab.)

If you try it again and it fails, you may want to post back with more
info--including the version of excel and that setting.

AccessHelp wrote:

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

--

Dave Peterson

I could still see the comment when I did what you did.

But since you have AutoFilter checked, I bet that the comment is showing--it's
just way off the screen.

If you show all the data, I bet it shows up closer to the cell.

Debra Dalgleish has a way to reposition them when they move where you don't
want them:

http://contextures.com/xlcomments03.html#Reset

AccessHelp wrote:

Hi Dave,

Thanks for your help. I am also using Excel 2003, and I do have the
"Comment Indicator Only" selected.

When I protect the sheet, in addition to the two items that you mentioned, I
also have the following boxes checked: "Format columns", "Format rows",
"Insert rows" and "Use AutoFilter". I have those checked so that the users
can hide, insert and expand the rows and columns and use the filter.

In addition to those items, again, if I have the Edit objects box checked,
not only the comment would show, you can even edit it. If I don't have it
checked, the comment would not show at all, but you can see the comment
indicator in the cell. When I move the mouse over to the cell, it turns into
a hand pointer.

In the Format Comment, both lock boxes are checked.

Thanks again.

"Dave Peterson" wrote:

I just tried this in xl2003.

I added a comment to a cell.
I protected the worksheet (just "select locked cells" and "select unlocked
cells" were checked).

The comment showed up when I moused over that cell with the comment.

(I had "Comment indicator only" checked in tools|Options|view tab.)

If you try it again and it fails, you may want to post back with more
info--including the version of excel and that setting.

AccessHelp wrote:

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

--

Dave Peterson


--

Dave Peterson

Thanks Dave.

After playing around with it, I found a way to ask the users to see it. I
didn't check the Edit objects box, and I checked both lock boxes in the
Format Comment. When I move the mouse over, it still would not show it.
Then what I did was, I right-click on one of the headers (the one with a
comment) and click on Show/Hide Comments from the drop-down menu. At that
time, it showed the comment.

I guess, I can just ask the users to do the same way if they want to see the
comments.

Thanks again.

"Dave Peterson" wrote:

I could still see the comment when I did what you did.

But since you have AutoFilter checked, I bet that the comment is showing--it's
just way off the screen.

If you show all the data, I bet it shows up closer to the cell.

Debra Dalgleish has a way to reposition them when they move where you don't
want them:

http://contextures.com/xlcomments03.html#Reset

AccessHelp wrote:

Hi Dave,

Thanks for your help. I am also using Excel 2003, and I do have the
"Comment Indicator Only" selected.

When I protect the sheet, in addition to the two items that you mentioned, I
also have the following boxes checked: "Format columns", "Format rows",
"Insert rows" and "Use AutoFilter". I have those checked so that the users
can hide, insert and expand the rows and columns and use the filter.

In addition to those items, again, if I have the Edit objects box checked,
not only the comment would show, you can even edit it. If I don't have it
checked, the comment would not show at all, but you can see the comment
indicator in the cell. When I move the mouse over to the cell, it turns into
a hand pointer.

In the Format Comment, both lock boxes are checked.

Thanks again.

"Dave Peterson" wrote:

I just tried this in xl2003.

I added a comment to a cell.
I protected the worksheet (just "select locked cells" and "select unlocked
cells" were checked).

The comment showed up when I moused over that cell with the comment.

(I had "Comment indicator only" checked in tools|Options|view tab.)

If you try it again and it fails, you may want to post back with more
info--including the version of excel and that setting.

AccessHelp wrote:

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

--

Dave Peterson


--

Dave Peterson

Just another comments related query. Is there a way of getting comments
to appear on the left rather than the right.

I have info in all the columns on the screen with comments in te most
right hand column. When I mouse over them the appear, but are off the
screen. If I reposition the comment to the left, it only pops up there
if I want to edit it, but still pops up on the right on mouseover.

Is there a way around it, has Micro$oft just missed a trick here? Seems
a bit of an oversight if they have.

Cheers,

Mark.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=499423