WordArt in Header, Excel

konfiskation · #1 12-02-2010, 12:33 AM

Hey,

I achieved to generate a WordArt Object with the following code:

Code:

               
     dim DateArt As Shape 
       
       x = "Created" & vbLf & Format(Date, "DD.MM.YYYY") 
       Set DateArt = wss.Shapes.AddTextEffect(PresetTextEffect:=msoTextEffect14, text:=x, _ 
            FontName:="Arial Black", FontSize:=18, FontBold:=msoFalse, FontItalic:=msoFalse, _ 
            Left:=500, Top:=-40) 
      DateArt.Rotation = 30

In Excel I would like to put that WordArt Object into the header and not to have it as a objet on a worksheet ('wss').

Is is actually possible in Excel? I could not find anything on the internet.

Thank you very much

Groetjes
Moritz

BTW: If you also know how make the text transparent I would really appreciate some comments about it

konfiskation · #2 12-06-2010, 03:56 AM

Nobody knows, or is it not possible?

Regards,
Konfiskation

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Apply WordArt to Slide Master Title box	jsmath22	PowerPoint	2	12-15-2010 07:20 AM
No Header Gap visible?	dr_mik	Word	0	11-25-2009 06:10 PM
WordArt over picture	bdp003	Drawing and Graphics	0	08-23-2009 02:40 AM
Excel 2003 - Different Header for each page	franklyorange	Excel	0	08-26-2008 02:26 PM
Pub 2004+...What Happened to WordArt ???	mark4man	Publisher	0	02-14-2007 06:29 PM