Make a file, including macros, made in excel 95 work using an excel 97 2003 ?

I have a golf handicap program made in excel 95, with all its worksheets and macros. Now using excel 97 2003, I can view it but can no longer see the macros. It also does not work anymore. How can I see the macros so it can be reprogrammed? Or better yet, I can I make it work?

Thanks, will check it out.

Looks like the file is already corrupt. So, with your help I will try to redo it all over. The file has originally 9 worksheets. on one of the worksheets,the following formulas are on some cells.

What does the following mean? I recall they refer to a table in another worksheet or a drop down in another worksheet.

1. =IF(L8>VLOOKUP(Handicap,HCPT,3),VLOOKUP(Handicap,HCPT,3),L8)

2. =IF(F8=VLOOKUP(Handicap,HCPT,3),1,0)

3. =VLOOKUP(SCRC,SCRT,2)

4. =VLOOKUP(CSEC,CSET,2)

Thank you