I wrote a bunch of Macros on my machine that runs Office XP, made them
into an Add-In and sent it out to everyone. Now the people that have
Excel 97 are getting errors and can't run the Marcos. It seems that I
used constants that aren't in VBA 5 (I think that is what Excel 97
uses) and therefore when the constant is undefined it error out. How
can I correct this? Define all the constants I used? Or is there a
way to find out which aren't available in 97 and somehow replace them?
Any ideas would be great.

-Steve