I have a small problem, I can't figure out.
I add a horizontal line with something like this:
With Selection.InlineShapes.AddHorizontalLineStandard
.Width = CentimetersToPoints(6)
.Height = 0.8
.Fill.Solid
.Fill.ForeColor.RGB = RGB(0, 0, 0)
.Fill.BackColor.RGB = RGB(0, 0, 0)
End With
Problem is that .Solid doesn't seem to work, and I can't figure out how to access the properties box while recording a macro to see how to do it. When right clicking a line and choosing Format horizontal line there's an option called Use solid color (no shade), which makes the line solid black...I can't figure out how to activate that with VBA.
The .Fill.Solid doesn't make any errors, but the line doesn't go all black (and it doesn't get ticked) as if I chose the option manually...
Any help is very much appreciated!!
I add a horizontal line with something like this:
With Selection.InlineShapes.AddHorizontalLineStandard
.Width = CentimetersToPoints(6)
.Height = 0.8
.Fill.Solid
.Fill.ForeColor.RGB = RGB(0, 0, 0)
.Fill.BackColor.RGB = RGB(0, 0, 0)
End With
Problem is that .Solid doesn't seem to work, and I can't figure out how to access the properties box while recording a macro to see how to do it. When right clicking a line and choosing Format horizontal line there's an option called Use solid color (no shade), which makes the line solid black...I can't figure out how to activate that with VBA.
The .Fill.Solid doesn't make any errors, but the line doesn't go all black (and it doesn't get ticked) as if I chose the option manually...
Any help is very much appreciated!!