I've an excel2007 tool that plots autoshapes and uses the Addlabel method to add a text box to each one.
The text is invariably split across two lines with a chr(10) new line.
The textframes have Autosize=true set and this (kinda) works.
What happens is that the second line of text is only visible at worksheet zoom levels of around 80% and greater magnification. Below this, only the text before the chr(10) line break is visible.
What's really annoying me is that if you right click on a label shape and follow the Format shape dialogue to the Textbox->autofit section, the checkbox is ticked. If you now cycle this checkbox off and back on, the size of the box does not change, but the second line of text now becomes visible at all zoom levels.
I've gone so far as to write a teeny routine to cycle through all my labels at the end of processing to flip Autosize off and back on again, but this doesn't work - there seems to be no substitute for manually flicking the Autofit checkbox.
Final part of the conundrum - my tool exports the finished shapes up PowerPoint as an Enhanced Metafile picture. The pasted picture has no issues - I.e. The second lines of text are always visible even if Excel was refusing to show them at the zoom level I copied them from...