He could program around them, by isolating the 2002 code in modules that do
not get called when the code is run in Excel 2000, but that can be tricky
and does depend on how the code is structured. This would eliminate the
run-time errors, but the compile errors would still occur.

Cleanest way is to develop in Excel 2000.

--
http://www.standards.com/; See Howard Kaikow's web site.
"Tom Ogilvy" wrote in message
...
there is no difference in formats since xl97.

Getting the compile errors is what he is getting now. He wants some
automatic way to fix them - I don't believe there is a way to do that.

--
Regards,
Tom Ogilvy

"Keith Willshaw" wrote in message
...

"tom" wrote in message
...
is there another way then creating the macro in the older
excel version? this takes tooo long (e.g. siable the
feature in excel 2000?


Just do a save as into Excel 2000 format and
open Excel 2000 , you should get the errors
when you compile

It that doesnt work export the code modules from 2002
and load em into 2000

Keith