VB code is not shown when recording drawing objects

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joakim Norrman - 26 Jan 2008 13:12 GMT

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?

Reply to this Message

Bob Flanagan - 26 Jan 2008 13:17 GMT

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

> For example in Excel 97 when recording creation af a rectangle, following
> VB
[quoted text clipped - 4 lines]
>
> Does anybody know why this code is not recorded in Excel 2007?

Reply to this Message

JLGWhiz - 26 Jan 2008 17:01 GMT

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

> Microsoft did a _____ job. Your choice on filling in the blank!
>
[quoted text clipped - 15 lines]
> >
> > Does anybody know why this code is not recorded in Excel 2007?

Reply to this Message

Tim Zych - 26 Jan 2008 19:02 GMT

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

Signature

Tim Zych
SF, CA

> For example in Excel 97 when recording creation af a rectangle, following
> VB
[quoted text clipped - 4 lines]
>
> Does anybody know why this code is not recorded in Excel 2007?

Reply to this Message