VB Excel Macros no longer run under Vista/Office 2007

[dynamo2000]

Awhile back I upgraded my system to Vista & Office 2007, Enterprise ed. Prior to the upgrade I had written a number of macros for Excel in VB which worked fine. Now, when I try to run the same macros, I am getting errors pertaining to intrinsic functions such as: gcd(), lcm() and even right(). Apparently, libraries that were available in the earlier versions of Office are not loaded with Office 2007. Is there a simple way to find, load and make available some library(ies) for my VB code in Office/Excel which includes the functions listed above?

[IcemanND]

no need to double posst.

[mikeatwork]

i have had little input on the macros from 2000 to 2007 but from what i have heard yes they are different but most problems are sorted if you open the code in office 2007 and recompile it