Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Err 1004 from VBA Charts
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Err 1004 from VBA Charts
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Err 1004 from VBA Charts
I turn off all the "auto scale" option in the "Format Chart Area- Fonts" and
still get the same message. Is there something else I can try ? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Err 1004 from VBA Charts
Not really.
You could try remapping any styles that use non-standard fonts in your workbook to reduce your other fonts. See the style mapper on my site as a quick way to do this. Whatever you do though, the charts will take up fonts. Otherwise, what version of excel, and how many charts are you talking about. Robin Hammond www.enhanceddatasystems.com "ch" wrote in message ... I turn off all the "auto scale" option in the "Format Chart Area- Fonts" and still get the same message. Is there something else I can try ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link excel charts to web pages and update charts automatically | Charts and Charting in Excel | |||
Charts - How to have multiple charts share a legend. | Charts and Charting in Excel | |||
Charts.Add error '1004' Method 'Add' of object 'Sheets' failed | Charts and Charting in Excel | |||
Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel | |||
Charts.Add - Run-time error 1004 pls help | Excel Programming |