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 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

On Sep 16, 1:51*am, isabelle <i...@v.org> 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