Comment box size
 

Is there a way to control the size of the comment box. Currently the box
opens as about a 2 X 3 in box. I would prefer to have it open as a rectangle.
I know that can be adjusted by using the handles...but can the rectancle size
be set as a default?
Thanks

Comment box size
 

Hi

I'd try a macro from Debra Dalgleish's site:
http://contextures.com/xlcomments03.html#Resize

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm



"pcor" wrote:

Is there a way to control the size of the comment box. Currently the box
opens as about a 2 X 3 in box. I would prefer to have it open as a rectangle.
I know that can be adjusted by using the handles...but can the rectancle size
be set as a default?
Thanks

Comment box size
 

Many thanks that was real good advice and also thank to Debra for providing
such good help

"Eduardo" wrote:

Hi

I'd try a macro from Debra Dalgleish's site:
http://contextures.com/xlcomments03.html#Resize

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm



"pcor" wrote:

Is there a way to control the size of the comment box. Currently the box
opens as about a 2 X 3 in box. I would prefer to have it open as a rectangle.
I know that can be adjusted by using the handles...but can the rectancle size
be set as a default?
Thanks