I see.
1. In Excel, go to menu Tools AddIns , add the "Analysis Toolpack - VBA"
Be carefull here, there is another one called "Analysis Toolpack" with no
"VBA"
2. In the VBA Editor (ALT+F11), select the project/workbook containing the
code.
Go to menu (in the editor) Tools References, add a check on
'atpvbaen.xls' (or similar name) based on your language. It should be located
close from the begining of the list.
3. Compile your project: menu Debug Compile.
Any error?

I hope this help,
Sebastien