hindersaliva
asked on
Excel 2007 ShapeStyle presets
I have a shape which starts off as
oBlock1.ShapeStyle = msoShapeStylePreset23
I want to programmatically make that have a Thick Black Border, but without altering the Fill Style of light blue.
When I do that with
oBlock1.ShapeStyle = msoShapeStylePreset1
The Fill Style changes to White :(
How can I only alter the Border?
Thanks experts!
oBlock1.ShapeStyle = msoShapeStylePreset23
I want to programmatically make that have a Thick Black Border, but without altering the Fill Style of light blue.
When I do that with
oBlock1.ShapeStyle = msoShapeStylePreset1
The Fill Style changes to White :(
How can I only alter the Border?
Thanks experts!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER