VB code is not shown when recording drawing objects
 

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?

VB code is not shown when recording drawing objects
 

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

"Joakim Norrman" wrote in message
...
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?

VB code is not shown when recording drawing objects
 

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

"Bob Flanagan" wrote:

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

"Joakim Norrman" wrote in message
...
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?

VB code is not shown when recording drawing objects
 

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



--
Tim Zych
SF, CA


"Joakim Norrman" wrote in message
...
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?