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!
hindersalivaAsked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

Since the Stylepresets are pre-set

pls try

    oBlock1.ShapeStyle = msoShapeStylePreset23
    oBlock1.Line.Weight = 3
    oBlock1.Line.ForeColor.RGB = vbBlack

Open in new window

Regards
0
 
hindersalivaAuthor Commented:
Hey thanks Rgonzo. That works for me :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.