View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kjs kjs is offline
external usenet poster
 
Posts: 5
Default Differences in Excel macro recording from 2003 to 2007! Help!

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?