Problem With Recording a Macro in Excel 2007

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
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
 
Hopefully in the next version of Office. I don't expect they'll bother
including this in a service pack.

- Jon
 
Back
Top