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 he

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