| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access custom chart autoformats
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 _______ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Charts and Charting in Excel | |||
| Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Setting up and Configuration of Excel | |||
| How do I color code a Pivot Table - not standard Autoformats? | Excel Discussion (Misc queries) | |||
| Autoformats in Excel 2002 | New Users to Excel | |||
| Excel2002 autoformats dates, | Excel Programming | |||
Hybrid Mode
