Disable AutoSize for all fonts in chart?

Is there a way - either with a checkbox option or VBA - to disable the
AutoSize option for all fonts in a chart? Or do I have to format every
axis, title, etc. separately to remove this "feature"?

Ed

Jon Peltier has information on changing the registry setting for font
autoscaling:

http://peltiertech.com/Excel/Charts/FixFonts.html

Ed wrote:
> Is there a way - either with a checkbox option or VBA - to disable the
> AutoSize option for all fonts in a chart? Or do I have to format every
> axis, title, etc. separately to remove this "feature"?
>
> Ed
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Ed,

Yes, you can disable the font sizing with VBA. Jon Peltier has some
examples of the code here:

http://peltiertech.com/Excel/Charts/FixFonts.html

--
Regards,
John Mansfield
http://www.pdbook.com


"Ed" wrote:

> Is there a way - either with a checkbox option or VBA - to disable the
> AutoSize option for all fonts in a chart? Or do I have to format every
> axis, title, etc. separately to remove this "feature"?
>
> Ed
>
>
>