You need to eliminate the use of features of Excel 2002 VBA not supported by
Excel 2000 VBA.
One way to do this is to develop the code using Excel 2000, instead of Excel
2002.

--
http://www.standards.com/; See Howard Kaikow's web site.
"Tom" wrote in message
...
Hi all,

When trying to run a macro, created in excel XP, on a pc
with excel 2000 installed, the macro will find codes that
are not recognized in the older excel versions and
therefore not finish running. Is there any (simple) coding
available to avoid these problems from happening?

Thanks,
Tom