Office 2007

I have a large Excel spreadsheet that contains dozens of macros which I use at work and they work fine. At work we use Office 2002.
I have installed Office 2007 at home. When I try and use this same spreadsheet with Office 2007, it will not run any macros. I get a message that a VB Object cant be found. Any ideas how I get round this??

I beleive you should add the reference of Excel 2002 while working at home.

Not sure what you mean by reference???