Font color

[smi]

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

 

[Tom Ogilvy]

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.aspx?scid=kb;en-us;320531&Product=xlw
OFF: Changes to Fill Color and Fill Pattern Are Not Displayed

 

[Sandy V]

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

 

[smi]

Thank you for the help, Tom too. You guy are great.
Long