Problem With Recording a Macro in Excel 2007

[Bob]

I am in the process of trying to write a macro that includes inserting
pictures on the spreadsheet in a specific place with a specific size
depending upon specific things happening. I tried recording a macro in Excel
2007 to start the ball rolling, but it won't record anything to do with the
pictures. I went back to Excel 2003 and did it successfully, and then copied
the macro over to 2007 and it ran fine. What the heck? Does anybody know if
this is an inherent problem with Excel 2007? What's going on?

Thank you

 

[Jon Peltier]

The shape's and some of the chart's infrastructure has been rebuilt in 2007
and the macro recorder wasn't updated with the changes. This is a known and
inconvenient issue, but at least those of us who still have older versions
of Excel can use the older recorders. PowerPoint 2007 lost its recorder
completely.

- Jon

 

[Bob]

Thanks for the update Jon. Any clue when Microsoft will "make things right"?

 

[Jon Peltier]

Hopefully in the next version of Office. I don't expect they'll bother
including this in a service pack.

- Jon