ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Differences in Excel macro recording from 2003 to 2007! Help! (https://www.excelbanter.com/excel-programming/422787-differences-excel-macro-recording-2003-2007-help.html)

kjs

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?




All times are GMT +1. The time now is 07:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com