ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro Not Running in Excel 2007 (https://www.excelbanter.com/excel-programming/413244-re-macro-not-running-excel-2007-a.html)

Snookie1950

Macro Not Running in Excel 2007
 
We have 2 issues, both are solved when we make manual changes to:

One of the file locations referenced has /s instead of \s in 2003.

The other issue is that the macro referenced cell iv65536, which is the last
active cell in the 2003 format, however in 2007 the last active cell is
xfd1048576. Our tester changes the macro on their C: drive to look for
cz5000 and everything populated and finished running just fine.

--
Snookie


"Mike" wrote:

Post your code so that we can see.

"Snookie1950" wrote:

We have a macro in a 2003 workbook that is suppose to "go to" a particular
cell when the workbook opens. It works fine in 2003, but when the workbook
is opened in 2007, the macro hangs.
--
Snookie



All times are GMT +1. The time now is 03:04 PM.

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