Comment Box

[Troy]

I moved a comment box because when I froze the current
sheet and when I scrolled down, half of the comment would
get cut off. The only way I was able to show the comment
box in its new position was by unhiding it. If I had it
hid the move would not take effect. Is it possible to move
the comment box, hide the box, and when the cursor goes to
the cell with the comment, have the comment box appear in
its new position.
..

 

[David McRitchie (from Mozilla)]

Hi Troy,
Sorry you don't have control of where a comment box will reappear.

I imagine that what you are doing is the only choice you have for
very large comment boxes. When you unhide the comment you can
scroll your worksheet with the comment being scrolled along with the
worksheet.

I have a web page on cell comments, but I don't think any of it
applies to this particular question.
http://www.mvps.org/dmcritchie/excel/ccomment.htm

HTH,
David McRitchie, Microsoft MVP, Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm