Alter internal margins of chart title using VBA, Excel 2010
 

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

Alter internal margins of chart title using VBA, Excel 2010
 

hi Andreas

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


--
isabelle




Le 2011-09-15 18:18, AndreasHermle a écrit :
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

Alter internal margins of chart title using VBA, Excel 2010
 

On Sep 16, 1:51*am, isabelle wrote:
hi Andreas

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

--
isabelle

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







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

Hi isabelle:

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

Regards, Andreas