C
Chris Mauler
Hi,
is there any possibility in Excel2007 to change a line color from gradient
line color to solid line color or vice versa using VBA?
I have created a line with a gradient color from yellow to blue, this line
should turn into solid grey when the corresponding cell value is zero. When
using a solid line color in the first place there is no problem with
shape.line.forecolor.schemecolor=55, however, when using a gradient color
this command doesn't work, the line color remains gradient.
I haven't found any info in the Excel help, is there any solution to this?
Thanks in advance for any help,
Chris
is there any possibility in Excel2007 to change a line color from gradient
line color to solid line color or vice versa using VBA?
I have created a line with a gradient color from yellow to blue, this line
should turn into solid grey when the corresponding cell value is zero. When
using a solid line color in the first place there is no problem with
shape.line.forecolor.schemecolor=55, however, when using a gradient color
this command doesn't work, the line color remains gradient.
I haven't found any info in the Excel help, is there any solution to this?
Thanks in advance for any help,
Chris