Cant access functions from a VBA add in

Hi

I have received an excell add in containing VBA code. I have installed the add in, so that when i open excel and press Visual Basic tab then i can see all the code. However when I chose a cell in excel and start typing in the name of a function from the add in then the relevant function doesnt show up. What sohuld I do?

Thanks
Andy

are the functions public?

Yes, in the VBA code all functions start with "public function" if thats what your asking.
Thanks

Are those functions in a macromodule in the AddIn ?

Yes they are in a module
thanks

Try this in the cell on the worksheet and see if it works ..

Code:

---

=MyAddin.xlam!MyFunction(b2)

or if there are spaces

='My Addin has spaces.xlam'!MyFunction(b2)  (I think that's the proper format)

---

Does the module have Option Private Module at the top?

Which version of Excel do you have?