Hi Derek

when you use one of the saved charts
the fonts all play up.

Again I don't quite follow, what do you mean by "use". Do
you mean changing an old chart to new custom type. I doubt
if the problem is directly related to "update" macro which
(I assume) only does what you could have done manually.
Might be worth a repost describing the steps that lead to
the problem.

Just a guess, something to do with Font Autoscale perhaps.

BTW, did you distribute the update to 250 users, if so
what proportion responded. Also what was the
cause/solution to the problems you described on Aug 26th.

Regards,
Sandy

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

I now have most of the work done. However occasionally
it
is taking the chart and reducing all the fonts down to
3.5
or other rediculous values.

The graphs appear fine in the excel spreadsheet that I'm
going to have people open, but when you use one of the
saved charts the fonts all play up.

Help.

Derek


-----Original Message-----
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
_______


.

.