If you develop a macro to be used over multiple versions, the macro code has
to either take care to not use VBA not supported in earlier versions or to
appropriately design the code so code for later versions is not in the same
modules as code for earlier versions. In the latter case, you then choose
which code to execute at run time.

--
http://www.standards.com/; See Howard Kaikow's web site.
"Frank Krogh" wrote in message
...
I have read that in the excel help that "the Microsoft Excel 2002 file
format does not differ from the Microsoft Excel 2000 and Excel 97 file
formats, but it does differ from earlier versions". Unfortunately I have
received feedback that it doesn't seems to be a macro backward
compatibility
from Excel 2002 to Excel 2000.

I have unsuccessfully tried to save an Excel 2002 workbook as a Excel
2002/excel 97 compatible format, and there is no Excel 2000 option in the
"Save as type" rolldown menu.


Is there any way to solve this problem or workaround it?


Thanks for suggestions.


Frank Krogh