LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default "No more new fonts may be applied to this workbook". Say what?

This error is stopping my code dead in its tracks :-(

I'm programmatically creating charts when this error occurs. If I select the graph plot, right click "Format Data Series...", the error will pop up. Click OK
and then the standard "Format Data Series" window displays like normal. Is there a way to, uh, clear out the register or whatever that keeps tabs on this
setting?

Here's where the code is breaking:
....
chartAvgCalls.Axes(xlCategory).Select
Selection.TickLabels.AutoScaleFont = True
With Selection.TickLabels.Font
.Name = "Arial"
.FontStyle = "Bold" '<-- this is where the error occurs
.Size = 10
End With
....

Ideas?
Toby Erkson
Oregon, USA
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"no more new fonts may be applied to this workbook" ? is problem Clopez Charts and Charting in Excel 3 June 17th 07 07:20 PM
"No more new fonts may be applied in this workbook" error. Help. Mark Elliott Excel Discussion (Misc queries) 1 October 24th 06 11:32 PM
Repeat alert, "No more new fonts may be applied to this workbook" NoiseGuy Excel Discussion (Misc queries) 3 October 23rd 06 02:09 PM
"No more fonts may be applied in this workbook." when saved. Why? smileyG Excel Discussion (Misc queries) 0 January 12th 06 08:02 PM
"No more fonts may be applied in this workbook." when saved. Why? smileyG Excel Discussion (Misc queries) 0 January 11th 06 07:14 PM


All times are GMT +1. The time now is 07:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"