Comment box size

[pcor]

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

 

[Eduardo]

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]

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