macro issues with excel 97

[killian]

I have several macros in an excel 2002 workbook that will not run in excel 97.
Is there a way to determin if it will ever run or what is causing the problem?

 

[Jon Peltier]

See which command chokes Excel 97, then check in the object browser or
online help for 97 what the syntax for 97 has to be. There were a bunch of
major changes to VBA between 97 and 2000, and 2002 added some further
changes.

- Jon

 

[Gord Dibben]

There are a few new statements and methods in 2002 that were not in 97 but
generally macros should run.

IF we could see the code you would have a much better chance of getting more
help.

"will not run" doesn't give much to go on.


Gord Dibben MS Excel MVP