Alter internal margins of chart title using VBA, Excel 2010

[AndreasHermle]

Dear Experts:

Why is the following menu item greyed out in Excel 2007/2010?
.... Format Chart Title / Alignment / Internal Margins

I would like to alter the internal margins using VBA. Is this
possible?

Help is much appreciated. Thank you very much in advance.

Regards, Andreas

 

[isabelle]

hi Andreas

try putting. ChartTitle.AutoScaleFont = False or True depending on the result desired


--
isabelle




Le 2011-09-15 18:18, AndreasHermle a écrit :

 

[AndreasHermle]

hi Andreas

try putting. ChartTitle.AutoScaleFont = False or True depending on the result desired

Hi isabelle:

ok, thank you very much for your quick support. I will give it a try
tomorrow and let you know.

Regards, Andreas