Changing Color Palette
 

I know how to change the color palette. The problem is: changes do not
stick if I open the workbook on a different computer. I am working with
a macro and would like to use something like
ColorIndex(3)=RGB(207,254,255) to set some soft pastel colors. Is there
a way to do this?

Incidently, while trying to do this I discovered that the color palette
makes no sense at all! There is no relationship between the ColorIndex
and the position on the chart or the color spectrum. One wonders what
logic process was used to develop this chart in which index numbers
range from 1 - 56, but 17-32 are missing. And if you customize a color,
the color changes but the index number stays the same. Go figure!

kaldon

Changing Color Palette
 

Use code like

ThisWorkbook.Colors(3) = RGB(207,254,255)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"kaldon" wrote in message
oups.com...
I know how to change the color palette. The problem is: changes
do not
stick if I open the workbook on a different computer. I am
working with
a macro and would like to use something like
ColorIndex(3)=RGB(207,254,255) to set some soft pastel colors.
Is there
a way to do this?

Incidently, while trying to do this I discovered that the color
palette
makes no sense at all! There is no relationship between the
ColorIndex
and the position on the chart or the color spectrum. One
wonders what
logic process was used to develop this chart in which index
numbers
range from 1 - 56, but 17-32 are missing. And if you customize
a color,
the color changes but the index number stays the same. Go
figure!

kaldon

Changing Color Palette
 

That worked great! Thanks for the prompt response.

kaldon