I am able to control the weight of a graph in Excel VBA using the following code:
ActiveChart.Axes(xlCategory).Select
With Selection.Border
.ColorIndex = 57
.Weight = xlMedium
.LineStyle = xlContinuous
End With
When I try running this in Word VBA, I get the error
Compile error: Method or data member not found.
.Border is highlighted.
I experimented with the code
salesChart.Axes(xlCategory).Select
Selection.Borders(wdBorderBottom).Visible = True
and got the message
Run-time error '4605' This method or property is not available because the object refers to a drawing object.
I want to figure out a way to highlight the axes in the graph I'm embedded in a MS Word document through Word VBA
Aucun commentaire:
Enregistrer un commentaire