 |
 |
|
|
|
|
Welcome to the { mindfrost82.com } forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
05-22-2008, 08:21 PM
|
|||
|
|||
|
Excel2007: How to change line color from gradient to solid via VBA?
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 
|
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
