Disable AutoSize for all fonts in chart?

[Ed]

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]

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

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

 

[Guest]

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