There used to be something on MSDN about this but I can't find it.

So, from memory.
Each chart takes minimum 2 fonts.
Max font limit is 256.
Implied max chart limit is effectively 128.
To reduce font usage set Autoscale Fonts to false for each chart.

The problem was particularly bad in Office 97. I think they may have
increased the font usage limit since then.

Robin Hammond
www.enhanceddatasystems.com

"ch" wrote in message
...
Dear gurus,

I have a VBA program and one of the command is :

Charts.Add

This works fine for some spreadsheets. On other sheets, on different
workbook, VBA gives error message :


"Run Time Error - '1004' :

No more new fonts may be applied in this workbook."


What's wrong ? What can I do to overcome this error. I do not need any
new
fonts. I just want to create the charts with any fonts available.

Thanks.