If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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/ |
#2
|
|||
|
|||
Fixing Comment Box Position!!!!!
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/ |
#3
|
|||
|
|||
Fixing Comment Box Position!!!!!
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/ |
Thread Tools | |
Display Modes | |
|
|