vba code for inserting word art using in excel 2007
 

can anyone have the vba code for inserting word art in excel 2007? i tried to
record a macro for inserting a word art in excel 2007, after inserting the
word art and hit the stop recording, when i check the code, no codes were
generated.

any help?

thanks

vba code for inserting word art using in excel 2007
 

Recoreded using Excel 2002:

Sub Macro2()
'
' Macro2 Macro
' Macro recorded 1/13/2009 by James Ravenswood
'

'
ActiveSheet.Shapes.AddTextEffect(msoTextEffect14, "my text here",
"Impact", _
36#, msoFalse, msoFalse, 276.75, 136.5).Select
Application.CommandBars("WordArt").Visible = False
End Sub

perhaps 2007 is the same.
--
Gary''s Student - gsnu200826


"psycho802" wrote:

can anyone have the vba code for inserting word art in excel 2007? i tried to
record a macro for inserting a word art in excel 2007, after inserting the
word art and hit the stop recording, when i check the code, no codes were
generated.

any help?

thanks