B
BobRoyAce
I am trying to create a macro that will put a border around a picture,
on all sides. The user will have to first select the picture, by
clicking on it. Then, they will fire off the macro, either with a
keyboard shortcut, or a button click. Upon doing so, I want the
picture to have borders on all sides. Here's the code that I tried,
but it seems to only put borders on the right and left sides. Any help
would be muchly appreciated.
--- MACRO CODE BEGINS ---
Selection.InlineShapes(1).Line.Weight = 1.25
Selection.InlineShapes(1).Line.DashStyle = msoLineSolid
Selection.InlineShapes(1).Line.Visible = msoTrue
Selection.InlineShapes(1).Line.ForeColor.RGB = RGB(0, 0, 0)
--- MACRO CODE ENDS ---
on all sides. The user will have to first select the picture, by
clicking on it. Then, they will fire off the macro, either with a
keyboard shortcut, or a button click. Upon doing so, I want the
picture to have borders on all sides. Here's the code that I tried,
but it seems to only put borders on the right and left sides. Any help
would be muchly appreciated.
--- MACRO CODE BEGINS ---
Selection.InlineShapes(1).Line.Weight = 1.25
Selection.InlineShapes(1).Line.DashStyle = msoLineSolid
Selection.InlineShapes(1).Line.Visible = msoTrue
Selection.InlineShapes(1).Line.ForeColor.RGB = RGB(0, 0, 0)
--- MACRO CODE ENDS ---