colors change magically
 

I've worksheets where I've made custom colors.

Sometimes, when I email them, open them on different computers, or even
just open them on my computer after working with other .xls files, the
custom color has reverted to it's origional color or something
completely new.


I'm wondering how I make a custom color stay what I made it be under:


tools - option - color - (select color) - modify - custom - RGB


and not have it change to something new or the origional standard
color.


Thanks,


Sam

colors change magically
 

Hi Sam,
The color definition should be with the workbook (not the sheet).
Is everyone using Excel 97 through Excel 2003. That is my understanding
and I'm sure it was yours as well or you'd not be surprised.
http://www.mvps.org/dmcritchie/excel/colors.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"samearle" wrote in message ...
I've worksheets where I've made custom colors.

Sometimes, when I email them, open them on different computers, or even
just open them on my computer after working with other .xls files, the
custom color has reverted to it's origional color or something
completely new.


I'm wondering how I make a custom color stay what I made it be under:


tools - option - color - (select color) - modify - custom - RGB


and not have it change to something new or the origional standard
color.


Thanks,


Sam