.TintAndShade under Excel2003

  • Thread starter Thread starter Tamas Konczer
  • Start date Start date
T

Tamas Konczer

Hi

It seems that the .TintAndShade does not work under Excel 2003. Any
idea how could I replace this?
 
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:
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Border formatting row of cells 22
Runtime error on a PC: Selection.Borders(xlEdgeLeft).TintAndShade =-0.14996795556505 2
Help with mess of code 1
Run Time error 1004 - Pastespecial method of range class failed. 3
Trying to format a cell with a border 7
How to rewrite this code? (first half) 1
GridLines Inadvertantly Goes Away with Macro 3
How I can get color (RGB value) from .ThemeColor + .TintAndShade? 2

Back
Top