Hi Derek,

I opened a chart and tried to change the chart type
to the one that was added in the macro. /../
It's just the automatic one that is crashing.

I don't quite follow. Do you mean crashes when changing a
standard type chart to a new "User defined" type that's
just been updated in xlusrgal.xls?

What happens if you create a new chart of the type that
crashed when changing an existing chart?

Don't know if this is relevant:
I notice when xlusrgal.xls updates so does Xl8galry.xls,
seems they work as a pair. The latter stores the "Built in
Custom" types, they are both in the same (sub) directory
of /Office.

I wonder if there is any network confusion. Depending on
whether the user is/not logged on, which pair of these
chart files is accessed/updated. Might be worth
experimenting and looking at file dates of the user's and
networks pair of chart files.

Another thing to try:
Load your file to another terminal but disable macros or
beforehand rename the Auto_open()
Manually add the new custom charts, in effect do the same
as the macro being careful to use same names. You should
end up with the same problem, but if not should give a
clue.

Regards,
Sandy

-----Original Message-----
Hi Guys

I've just gotten back on to this after a break and
applied
the logic you suggested in your winter post.

Everything worked fine until I opened a chart and tried
to
change the chart type to the one that was added in the
macro.

I got the MS Office "Do you want to send a crash report
to
Microsoft" error.

I can save this chart manually and then use it fine.
It's
just the automatic one that is crashing.

Any ideas of what I could look at?

Thanks
Derek


-----Original Message-----


Sandy V wrote:
Derek
Looks like Jon Peltier & I were following up at the
same
time. As he has previously suggested similar but
better
(I hadn't seen his "winter post") I think you can be
more
confident this is the way to go.

Re use a different method
See Jon's code

Regards,
Sandy

PS to Jon
In our last exchange in May you mentioned

Isn't that fun.

to which I meant to reply - "No !"


Sandy -

I don't remember, but my tone of voice sounds familiar!

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______