VB code is not shown when recording drawing objects

[Joakim Norrman]

For example in Excel 97 when recording creation af a rectangle, following VB
code was shown:

ActiveSheet.Shapes.AddShape(msoShapeRectangle, 25.5, 26.25, 155.25,
36.75).Select

Does anybody know why this code is not recorded in Excel 2007?

 

[Bob Flanagan]

Microsoft did a _____ job. Your choice on filling in the blank!

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[JLGWhiz]

Bob, does that mean you don't especially care for xl2007 release?

 

[Tim Zych]

This article confirms it, but it doesn't describe why MS made XL2007 so
lame.

You cannot record new shapes, shape formatting, and shape effects by using
the macro recorder in Excel 2007
http://support.microsoft.com/kb/937620/en-us