Please help, I am using Excel 97 with Win 95.
I use VBA to change color of some cell. It work great at my computer but
then when I use it at my friend PC, it did not change color. Did anyone ever
have this problem? If yes please show me how to fix this.
Thank you for your time.
Long

I know you said you are using Excel 97 and Win 95 and the article below is
for xl2002, but perhaps your friend is using xl2002, so see if this is the
problem:

http://support.microsoft.com/default...31&Product=xlw
OFF: Changes to Fill Color and Fill Pattern Are Not Displayed

--
Regards,
Tom Ogilvy




"smi" wrote in message
...
Please help, I am using Excel 97 with Win 95.
I use VBA to change color of some cell. It work great at my computer but
then when I use it at my friend PC, it did not change color. Did anyone
ever
have this problem? If yes please show me how to fix this.
Thank you for your time.
Long

Did you change color with colorindex. If so check if it
returns what you set, eg
Msgbox selection.interior.colorindex

If you applied a color value such as RGB(r,g,b) or vb
color constant, results might not be the same if files
have different customized palettes (converted to nearest
matching palette colour and it's colorindex applied).

Otherwise check system High Contrast settings.

Regards,
Sandy

-----Original Message-----
Please help, I am using Excel 97 with Win 95.
I use VBA to change color of some cell. It work great at
my computer but
then when I use it at my friend PC, it did not change
color. Did anyone ever
have this problem? If yes please show me how to fix this.
Thank you for your time.
Long


.

Thank you for the help, Tom too. You guy are great.
Long
"Sandy V" wrote in message
...
Did you change color with colorindex. If so check if it
returns what you set, eg
Msgbox selection.interior.colorindex

If you applied a color value such as RGB(r,g,b) or vb
color constant, results might not be the same if files
have different customized palettes (converted to nearest
matching palette colour and it's colorindex applied).

Otherwise check system High Contrast settings.

Regards,
Sandy

-----Original Message-----
Please help, I am using Excel 97 with Win 95.
I use VBA to change color of some cell. It work great at
my computer but
then when I use it at my friend PC, it did not change
color. Did anyone ever
have this problem? If yes please show me how to fix this.
Thank you for your time.
Long


.