Hi Fredrik,

To the best of my knowledge you can only apply colors from the current
workbook's color pallete and the color is referenced not by its color but by
its position.

If you use my suggestion of the XLA macro you can put the XLA on a server
and tell each user how to attach it. Once attached all they will need to do
in the future is press the shortcut key whenever they open an old file with
chart which they want to have updated to the new color scheme. It's a one
time process for each file, not each chart. If you need to know how to make
the file an xla and attach it, let me know.
--
Cheers,
Shane Devenshire


"Fredrik E. Nilsen" wrote:

I have one more question about user-defined charts:

Is it possible to define the colours to be used? I can change the
colours in usrgal.xls but when I apply the user-defined chart, the
colurs revert to those in the current workbook.

Any way around this? The users can not be expected to import the
colours for every book and they have a lot of old books in wich they
are going to use the new colour-set.

--
Fredrik E. Nilsen