Thanks a lot, Jon. I thought I looked through all of the properties
and methods of Application, but somehow managed to miss that one.
Excel VBA isn't exactly my forte (I'm mainly a C++ person), so the
help is greatly appreciated.

John Shell

On Fri, 16 Feb 2007 13:06:21 -0500, "Jon Peltier"
wrote:

To avoid flashing:

Application.ScreenUpdating = False
Workbooks.Open strUsrGalFile, ReadOnly:=True
Application.ScreenUpdating = False

You can only delete or apply formats if you know their names ahead of time.
I don't think you can access the user defined chart types without opening
the user gallery workbook.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______