Fixing Comment Box Position!!!!!

I have a worksheet that I have put comment boxes on numerous cells. I
have coded the sheet to display the comment box when the cell is
selected. I am now running into a problem because the size, shape and
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? I
want the box to display the information in an ideal location on the
page. Please Help!!!!


---
Message posted from http://www.ExcelForum.com/

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 " wrote in message ...
I have a worksheet that I have put comment boxes on numerous cells. I
have coded the sheet to display the comment box when the cell is
selected. I am now running into a problem because the size, shape and
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? I
want the box to display the information in an ideal location on the
page. Please Help!!!!


---
Message posted from http://www.ExcelForum.com/

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

Thanks for the help.


---
Message posted from http://www.ExcelForum.com/