using vba to copy user-defined chart type
 

My vba makes charts in Excel. I have a file that contains all of the code
and is used to generate other files with the charts. The charts have a
user-defined type. This means that others can not use the file unless they
have the same definitions.
I have hidden a sheet with a chart and tried to make the code "add" the
definition when it runs so that when it generates the charts the definition
will be there. However, it doesn't work.
This is what I have:
Sheets("Control Chart").Select
ActiveChart.ChartArea.Select
Application.AddChartAutoFormat Chart:=ActiveChart, Name:="willy", _
Description:=""
ActiveChart.ApplyCustomType ChartType:=xlUserDefined, TypeName:="willy"

Any ideas?

TIA