View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Toby Erkson[_2_] Toby Erkson[_2_] is offline
external usenet poster
 
Location: Portland, Oregon
Posts: 26
Default "No more new fonts may be applied to this workbook". Say what?

Modifying the Microsoft code, here's how to delete ALL charts in a workbook:

Sub Delete_All_Charts()
Dim ws As Worksheet, co As ChartObject
For Each ws In ActiveWorkbook.Worksheets
For Each co In ws.ChartObjects
co.Activate
ActiveWindow.Visible = False
Selection.Delete
Next co
Next ws
End Sub

--
Toby Erkson
Oregon, USA

"Toby Erkson" wrote in message
...
Dalgleish ;-)
From the http://peltiertech.com/Excel/Charts/FixFonts.html link you

supplied,
the last one (XL2000: Error Copying Worksheets...) I got this
http://support.microsoft.com/default...;EN-US;Q215573
and it gave me the answer. Now to incorporate it into my code.

Thank you :-)
--
Erkson