Excel 2007 - WordArt Help Needed

N

newsgroups

I have a problem with WordArt in Excel 2007. The code below works
perfectly fine in EXcel 97 through to 2003 but in 2007 the text
characters are filled white, but in earlier version they where
transparent.

I can't find how to set the transparency in Excel 2007 via code, but
can do it manually via the mouse/keyboard.

Any help most appreciated.

Set WaterMark = ActiveSheet.Shapes.AddTextEffect(msoTextEffect1, "This
is my Sample Text", _
"Arial Black", 36#, msoFalse, msoFalse, 175#, 200#)
With WaterMark
.Fill.Visible = msoFalse
.Fill.Transparency = 1#
.Line.Weight = 0.75
.Line.DashStyle = msoLineSolid
.Line.Style = msoLineSingle
.Line.Transparency = 1#
.Line.Visible = msoTrue
.Line.ForeColor.SchemeColor = 23
.Line.BackColor.RGB = RGB(255, 255, 255)
.Rotation = -30
End With

Regards,
Dennis.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Watermark macro 2
How to remove watermark 4
Hide/Show Shapes on Worksheet?? 2
What's the macro code to make the selected item 75% of its size, wantto keep proportions 2
VBA created shapes sometimes break ranks 2
Problem adding shape with VB .net 0
sizing a chart in Word that was created in Excel VBA 2
automatically update WordArt when calandar year is changed 0

Top