With each new version, a lot of new functionallity gets added to Exce
VBA. If you took advantage of this in a new version and then try t
run it in an old version, you're out of luck. You will either need t
recode for the old version or require them to run in the new version.

One example I struggle with is Format(Now,"MM/DD/YY") which works grea
in 2002 VBA, but hangs in 2000 VBA.



--
Message posted from http://www.ExcelForum.com