Macro Not Running in Excel 2007

[Snookie1950]

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.

 

[Mike]

Post your code so that we can see.

 

[Mike]

Post your code so that we can see.

 

[Mike]

Post your code so that we can see.

 

[Jim Rech]

If by 'hang' you mean it does not run at all you may not have installed VBA
with Office. It is not selected by default. Rerun Setup if in doubt. It's
under Shared Features.

--
Jim
| 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

 

[Snookie1950]

Yes, very large company and VBA was installed. We have 2 issues both are
solved if we go in and make manual changes to the code. I'm working on
posting what's going on in another message.

 

[Snookie1950]

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.