Differences in Excel macro recording from 2003 to 2007! Help!

K

KjS

1)
In Excel 2003 it was possible to record macros which included the drawing of
objects (Circles, arrows etc.). You could record a macro which painted
arrows and circles on the spreadsheet. When doing such a recording in Excel
2007 all the drawing commands are ignored. (No traces in the macro code at
all).
How can this function be obtained in the Excel 2007 version?
2)
The old 2003 macros with the drawing code included works almost: There will
be no runtime error, but e.g. the color codes return none or different
results. (Are the argument definitions changed from int to long or ?!?!?)
Does anyone have information or solutions to these problems?
 

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