Using VBA to Set Axes Color

[jswhip]

I can change the color, size, etc. of the axes colors manually - can this be done via VBA? I see how to set the value where it crosses, tick marks, etc.

I am using Excel 2007

Thank you.

 

[pgc01]

Hi

Yes. For ex., try this on the active chart to change the horizontal axis to green:

ActiveChart.Axes(xlCategory, xlPrimary).Border.Color = vbGreen