How to change the colour of a line
Thanks Tom
"Tom Ogilvy" wrote:
Assume were are not talking about borders on cells, but a line from the
drawing toolbar:
activesheet.Shapes("Line 1").Line.ForeColor.RGB = _
Range("B9").Interior.Color
--
Regards,
Tom Ogilvy
"Chris" wrote:
Hi,
I have a line on a worksheet and I would like to change the colour dependent
on a cell. How do I do the €˜change line colour part from say red to green.
Any help greatly appreciated.
Thanks
|