Anthony Berglas wrote:
XL 2007 only seems to AutoSize the Height of a text box, not the
Width.
This is different from XL 95..2003 which autosized both.


I have to admit, this statement leaves me stumped. I have never been
able to get the autosize feature to work properly in Excel <= 2003.
Whenever I use the autosize feature in the Format Shape window, it
automatically sizes the width, but all the text is in a single line.
Was there another method that I have been missing out on?

To get autosizing to work in my add-in, I spent many hours writing my
own algorithm. If there's an easier way, I'm going to be really ticked
at myself.

In fact, I though the TextFrame2 Autosize method in 2007 was a
Godsend.


Nick Hebb
BreezeTree Software
http://www.,breezetree.com