Problem With Recording a Macro in Excel 2007

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
 
J

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
 
J

Jon Peltier

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

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top