In Excel 2003, Tint and Shade only works for shapes. Other worksheet
elements (cells, charts, etc.) are stuck using the 56 palette colors
unadulterated.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Stefi" wrote in message
...
I tried the example in .TintAndShade Help, it worked for me, then

ActiveSheet.Shapes(1).Fill.ForeColor.TintAndShade = -1

also worked changing shape's shade by the specified value from -1 to 1.

Regards,
Stefi

"Tamas Konczer" ezt írta:

Hi

It seems that the .TintAndShade does not work under Excel 2003. Any
idea how could I replace this?