In my program, I have had a very big problem for this line :
Application.AddChartAutoFormat Chart:=ActiveChart, Name:=Type_Name$, _
VBA shows this error:

Run-time error '1004':
method 'AddChatAutoFormat' of object '_Application' failed.
also now, in Excel (not VBA) I can not create user defined chart ( Custom types >>>> User-defined) because Excel shows this error:
"Error accessing User-defined custom chart file."

my program had worked before. But now it does not work !!!!!!!
Do I have to reinstall Excel ????

Best wishes.