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: 23
Default No more fonts can be applied - with a twist

So it seems like the standard error (no more fonts can be applied to this
workbook). However this occurs when I try and make part of a cell comment
text bold, or when I try and save the spreadsheet for the first time (in this
case I get a stack of 'no more font' dialogue boxes before it does actually
save.

There ARE lots of embedded charts in the workbook, but they all have
ChartArea.AutoScaleFont = False (along with anything else I un-AutoScale,
such as text boxes and the like).

I have discovered several interesting things:
(a) I can add new charts without a problem;
(b) that the error upon saving can be removed if I save the workbook about
half-way through the task (which is a pretty intensive VBA program);
(c) if I save and then reload I can change the font to bold no problem.

Any clues on this little foible would be appreciated. The fix whereby I save
and close the sheet after each step seems somewhat clunky...

Cheers,

Matt
 
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 maybe applied in this workbook butter Excel Discussion (Misc queries) 0 February 10th 10 03:58 PM
No more new fonts may be applied in this workbook Bongard Excel Discussion (Misc queries) 0 November 19th 08 04:26 PM
no more new fonts may be applied in this workbook CC Excel Discussion (Misc queries) 0 October 3rd 08 02:40 PM
No more new fonts may be applied in this workbook Shelagh Excel Discussion (Misc queries) 1 February 13th 06 05:57 PM
Why do I get "No more new fonts may be applied in this workbook"? Bart Charts and Charting in Excel 1 August 9th 05 02:48 AM


All times are GMT +1. The time now is 11:01 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"