In message of Sat, 2 Aug 2014
08:03:51 in microsoft.public.excel.programming, Walter Briscoe
writes
In message of Fri, 1 Aug 2014 18:49:50 in
microsoft.public.excel.programming, GS writes
I don't do much with 'Shapes' but I'll play around with it over the
weekend...

Thanks, Garry.
I did not say that my Sub Macro1() should be run in a new WorkSheet.
I like to construct failures which are standalone and can easily be
ported by anyone interested. I shall play too. ;)

I have a hypothesis: Excel text boxes do not support automatic margins
in 2010.
In 2003, I right-clicked the box right hand edge and selected Format
Text Box... I selected the Margins Tab and found Automatic checked and
the margins blank. When I unchecked Automatic, the margins were given
values of Left: 0.25 cm, Top: 0.13 cm, Right: 0.25 cm and Bottom: 0.13
cm.
In 2010, I right-clicked the box right hand edge and, in the absence of
Format Text Box..., I selected Format Text Effect...
I selected the Text Box entry and found the same margins as given above,
but no automatic margin control.
Hence my hypothesis. I shall have to write some version-dependent code.
If I had support, I would raise a query with Microsoft on a possible
undocumented change.
--
Walter Briscoe