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

Hide/Show Shapes on Worksheet?? 2
How to remove watermark 4
Macro trouble: inserting 'watermark' 4
sizing a chart in Word that was created in Excel VBA 2
Can I toggle this Code - to Stamp and to UnStamp? 1
VBA created shapes sometimes break ranks 2
Graphic within Cell Comment (revisited) 2
modify Code to have Prompt instead of actual jpg 2

Top