software

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 quot;select locked cellsquot; and quot;select unlocked
cellsquot; were checked).

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

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

--

Dave Peterson

Hi Dave,

Thanks for your help. I am also using Excel 2003, and I do have the
quot;Comment Indicator Onlyquot; selected.

When I protect the sheet, in addition to the two items that you mentioned, I
also have the following boxes checked: quot;Format columnsquot;, quot;Format rowsquot;,
quot;Insert rowsquot; and quot;Use AutoFilterquot;. 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.

quot;Dave Petersonquot; wrote:

gt; I just tried this in xl2003.
gt;
gt; I added a comment to a cell.
gt; I protected the worksheet (just quot;select locked cellsquot; and quot;select unlocked
gt; cellsquot; were checked).
gt;
gt; The comment showed up when I moused over that cell with the comment.
gt;
gt; (I had quot;Comment indicator onlyquot; checked in tools|Options|view tab.)
gt;
gt; If you try it again and it fails, you may want to post back with more
gt; info--including the version of excel and that setting.
gt;
gt; AccessHelp wrote:
gt; gt;
gt; gt; I insert a comment in one of the locked cells. If I protect the sheet
gt; gt; without the Edit Objects box checked and when I point to that cell, the
gt; gt; comment won't show.
gt; gt;
gt; gt; On the other hand, if I protect the sheet with the Edit Objects box checked,
gt; gt; the comment will show; however, it will also allow the user to make changes
gt; gt; to the comment.
gt; gt;
gt; gt; My sheet contains multiple columns, and the column headers are protected. I
gt; gt; am inserting comments in the column headers so that the users know the
gt; gt; purpose of those columns and what to enter. I like it to be able to show
gt; gt; when the user points to the header, and I don't like the users able to change
gt; gt; the comments.
gt; gt;
gt; gt; Is there a way to do it?
gt; gt;
gt; gt; Thanks.
gt; gt;
gt; gt; Alan
gt;
gt; --
gt;
gt; Dave Peterson
gt;

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:

contextures.com/xlcomments03.html#Reset

AccessHelp wrote:
gt;
gt; Hi Dave,
gt;
gt; Thanks for your help. I am also using Excel 2003, and I do have the
gt; quot;Comment Indicator Onlyquot; selected.
gt;
gt; When I protect the sheet, in addition to the two items that you mentioned, I
gt; also have the following boxes checked: quot;Format columnsquot;, quot;Format rowsquot;,
gt; quot;Insert rowsquot; and quot;Use AutoFilterquot;. I have those checked so that the users
gt; can hide, insert and expand the rows and columns and use the filter.
gt;
gt; In addition to those items, again, if I have the Edit objects box checked,
gt; not only the comment would show, you can even edit it. If I don't have it
gt; checked, the comment would not show at all, but you can see the comment
gt; indicator in the cell. When I move the mouse over to the cell, it turns into
gt; a hand pointer.
gt;
gt; In the Format Comment, both lock boxes are checked.
gt;
gt; Thanks again.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; I just tried this in xl2003.
gt; gt;
gt; gt; I added a comment to a cell.
gt; gt; I protected the worksheet (just quot;select locked cellsquot; and quot;select unlocked
gt; gt; cellsquot; were checked).
gt; gt;
gt; gt; The comment showed up when I moused over that cell with the comment.
gt; gt;
gt; gt; (I had quot;Comment indicator onlyquot; checked in tools|Options|view tab.)
gt; gt;
gt; gt; If you try it again and it fails, you may want to post back with more
gt; gt; info--including the version of excel and that setting.
gt; gt;
gt; gt; AccessHelp wrote:
gt; gt; gt;
gt; gt; gt; I insert a comment in one of the locked cells. If I protect the sheet
gt; gt; gt; without the Edit Objects box checked and when I point to that cell, the
gt; gt; gt; comment won't show.
gt; gt; gt;
gt; gt; gt; On the other hand, if I protect the sheet with the Edit Objects box checked,
gt; gt; gt; the comment will show; however, it will also allow the user to make changes
gt; gt; gt; to the comment.
gt; gt; gt;
gt; gt; gt; My sheet contains multiple columns, and the column headers are protected. I
gt; gt; gt; am inserting comments in the column headers so that the users know the
gt; gt; gt; purpose of those columns and what to enter. I like it to be able to show
gt; gt; gt; when the user points to the header, and I don't like the users able to change
gt; gt; gt; the comments.
gt; gt; gt;
gt; gt; gt; Is there a way to do it?
gt; gt; gt;
gt; gt; gt; Thanks.
gt; gt; gt;
gt; gt; gt; Alan
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

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.

quot;Dave Petersonquot; wrote:

gt; I could still see the comment when I did what you did.
gt;
gt; But since you have AutoFilter checked, I bet that the comment is showing--it's
gt; just way off the screen.
gt;
gt; If you show all the data, I bet it shows up closer to the cell.
gt;
gt; Debra Dalgleish has a way to reposition them when they move where you don't
gt; want them:
gt;
gt; contextures.com/xlcomments03.html#Reset
gt;
gt; AccessHelp wrote:
gt; gt;
gt; gt; Hi Dave,
gt; gt;
gt; gt; Thanks for your help. I am also using Excel 2003, and I do have the
gt; gt; quot;Comment Indicator Onlyquot; selected.
gt; gt;
gt; gt; When I protect the sheet, in addition to the two items that you mentioned, I
gt; gt; also have the following boxes checked: quot;Format columnsquot;, quot;Format rowsquot;,
gt; gt; quot;Insert rowsquot; and quot;Use AutoFilterquot;. I have those checked so that the users
gt; gt; can hide, insert and expand the rows and columns and use the filter.
gt; gt;
gt; gt; In addition to those items, again, if I have the Edit objects box checked,
gt; gt; not only the comment would show, you can even edit it. If I don't have it
gt; gt; checked, the comment would not show at all, but you can see the comment
gt; gt; indicator in the cell. When I move the mouse over to the cell, it turns into
gt; gt; a hand pointer.
gt; gt;
gt; gt; In the Format Comment, both lock boxes are checked.
gt; gt;
gt; gt; Thanks again.
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; I just tried this in xl2003.
gt; gt; gt;
gt; gt; gt; I added a comment to a cell.
gt; gt; gt; I protected the worksheet (just quot;select locked cellsquot; and quot;select unlocked
gt; gt; gt; cellsquot; were checked).
gt; gt; gt;
gt; gt; gt; The comment showed up when I moused over that cell with the comment.
gt; gt; gt;
gt; gt; gt; (I had quot;Comment indicator onlyquot; checked in tools|Options|view tab.)
gt; gt; gt;
gt; gt; gt; If you try it again and it fails, you may want to post back with more
gt; gt; gt; info--including the version of excel and that setting.
gt; gt; gt;
gt; gt; gt; AccessHelp wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; I insert a comment in one of the locked cells. If I protect the sheet
gt; gt; gt; gt; without the Edit Objects box checked and when I point to that cell, the
gt; gt; gt; gt; comment won't show.
gt; gt; gt; gt;
gt; gt; gt; gt; On the other hand, if I protect the sheet with the Edit Objects box checked,
gt; gt; gt; gt; the comment will show; however, it will also allow the user to make changes
gt; gt; gt; gt; to the comment.
gt; gt; gt; gt;
gt; gt; gt; gt; My sheet contains multiple columns, and the column headers are protected. I
gt; gt; gt; gt; am inserting comments in the column headers so that the users know the
gt; gt; gt; gt; purpose of those columns and what to enter. I like it to be able to show
gt; gt; gt; gt; when the user points to the header, and I don't like the users able to change
gt; gt; gt; gt; the comments.
gt; gt; gt; gt;
gt; gt; gt; gt; Is there a way to do it?
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks.
gt; gt; gt; gt;
gt; gt; gt; gt; Alan
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;


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: www.excelforum.com/member.php...oamp;userid=29130
View this thread: www.excelforum.com/showthread...hreadid=499423You can use that code to reposition the comment, but I don't think you can do
anything to make it show on the left by default.

mevetts wrote:
gt;
gt; Just another comments related query. Is there a way of getting comments
gt; to appear on the left rather than the right.
gt;
gt; I have info in all the columns on the screen with comments in te most
gt; right hand column. When I mouse over them the appear, but are off the
gt; screen. If I reposition the comment to the left, it only pops up there
gt; if I want to edit it, but still pops up on the right on mouseover.
gt;
gt; Is there a way around it, has Micro$oft just missed a trick here? Seems
gt; a bit of an oversight if they have.
gt;
gt; Cheers,
gt;
gt; Mark.
gt;
gt; --
gt; mevetts
gt;
gt; ------------------------------------------------------------------------
gt; mevetts's Profile: www.excelforum.com/member.php...oamp;userid=29130
gt; View this thread: www.excelforum.com/showthread...hreadid=499423

--

Dave Peterson


Do you mean on the link to Debra Dalgleish's codes?

Which one should I use?--
mevetts------------------------------------------------------------------------
mevetts's Profile: www.excelforum.com/member.php...oamp;userid=29130
View this thread: www.excelforum.com/showthread...hreadid=499423Yep. From earlier in this thread:

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

contextures.com/xlcomments03.html#Reset
mevetts wrote:
gt;
gt; Do you mean on the link to Debra Dalgleish's codes?
gt;
gt; Which one should I use?
gt;
gt; --
gt; mevetts
gt;
gt; ------------------------------------------------------------------------
gt; mevetts's Profile: www.excelforum.com/member.php...oamp;userid=29130
gt; View this thread: www.excelforum.com/showthread...hreadid=499423

--

Dave Peterson


Sorry Dave, I think you must have misunderstood me. I want a way of
making the stay in the position I place them. If I move a comment to
the left of a cell, the next time I mousover the cell the box pops up
on the right again!--
mevetts------------------------------------------------------------------------
mevetts's Profile: www.excelforum.com/member.php...oamp;userid=29130
View this thread: www.excelforum.com/showthread...hreadid=499423