Fixing Comment Box Position!!!!!

[jphil1919]

I have a worksheet that I have put comment boxes on numerous cells.
have coded the sheet to display the comment box when the cell i
selected. I am now running into a problem because the size, shape an
position of my comment boxes will not stay where I initialy set them.
Is there a way to fix the size and position of my comment boxes?
want the box to display the information in an ideal location on th
page. Please Help!!!

 

[David McRitchie]

Hi .........................................,
You have no control over where comment boxes appear.

You do have control over their size, you can resize them individually
or with a macro you could use autofit or specific cell sizes.
http://www.mvps.org/dmcritchie/excel/ccomment.htm

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

 

[jphil1919]

I can change the location of where the box appears by dragging it to
different spot on the screen. The boxes stay in these positions whe
you use the arrows to select the cell but when you click on the cell i
goes back to the same spot. There has to be a way to get thi
positioning to stay put.

Thanks for the help