#NAME? with user-defined formula (VBA Project)

[Hannes]

I downloaded a VBA project from the internet (CallPremium) and saved it to
Visual Basics. The website said, in order for the function to work, I needed
to install "Analysis ToolPak", which I did as well. Now when I try to use the
public function I get a #NAME? error. Any ideas anyone?

Hannes

 

[Gary''s Student]

You may need to install in both the worksheet as well as VBA. From the VBA
window:

Tools > References and check the atpvbaen.xls checkbox.