Function error

[DavidK]

I have created a user defined function to calculate a royalty. It works in my file - as soon as I send the file to someone else it doesn't work - the cells change to "name" error
I've opened up VBA in the new file and the module is there.
The only thing that I can see is that if I try and insert the function again - the name comes up as the full file name not just "Royalty".
Any thoughts.

Dk

[Richard Buttrey]

I have created a user defined function to calculate a royalty. It works in my file - as soon as I send the file to someone else it doesn't work - the cells change to "name" error
I've opened up VBA in the new file and the module is there.
The only thing that I can see is that if I try and insert the function again - the name comes up as the full file name not just "Royalty".
Any thoughts.

Dk

Do you mean that **only** the module is there, and not the UDF?

Does the following URL help?

http://www.decisionmodels.com/calcsecretsj.htm