.TintAndShade under Excel2003

T

Tamas Konczer

Hi

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

Stefi

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:
 
J

Jon Peltier

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
 
Top