Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recording a macro for drawing a shape in Excel 2007

Status
Not open for further replies.

bullkater

Technical User
Jan 11, 2007
4
CH
Didn't I get the news or what's going on here?

When recording macros in Excel 2007, there's no problem until it comes to the recording of the insertion of a shape object or modification of an existing one. Then the recorded macro looks something like this:

Sub Macro1()
'
' Macro1 Macro
'

'
End Sub

Nothing recorded and I don't know why.

Thanks for your reply already,
Marc
 
Must be an enhancement.

I have successfully recorded the insertion and mofification of shapes in Excel 2002.
 
I need to precise: I'm talking about the shapes in the "Illustrations" box. Btw, "Pictures" and "Shapes" from this box are not recorded, but "ClipArt" and "SmartArt" are.

M

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top