Hi
I am using VBA to set the axes lineStyle and lineweight of the xlXYScatterSmooth graph of Excel2007.
The related codes is:
.......
ActiveChart.Axes(xlCategory).Select  
    With ActiveChart.Axes(xlCategory)
        ....
        .HasMajorGridlines = True
        .HasMinorGridlines = False
        ....
        .MajorGridlines.Border.LineStyle = xlDash
        .MajorGridlines.Border.Weight = xlThin
......

However,If I use cae operation of Excel2007, I can actually specify  the value of line weight, which is more accurate than "xlThin", and so does the lineStyle. In fact, the CAE operation can supply me more kinds of line styles than those listed in "Border" in VBA.

Meanwhile, I tried to use Record Tool to record the corresponding VBA codes that can specify the specific line weight value and line style such as shot dash line. Unfortunately, the critical codes can not be recorded.

So, my question is that is there a piece of VBA codes that can assist me to set the specific value of the line weight and specific linestyle such as short dash line?

By the way, I found that msoLineStyle may be helpful.

kindly regards