Using user-defined functions in formulas

[kualjo]

I created a function in VBA called "FWDMS" that I use in worksheet formulas. When I use it, however, I can't just enter "=FWDMS..." and it's required fields. I have to choose it from the User Defined list under Function category, and when it is entered into the worksheet, it appears as "=PERSONAL.XLS!fwdms.fwdms..." Is it this way because I have it under the Personal Macro Workbook? I use the function for numerous files and don't need to -- or want to -- store it in each individual file. How can I make this function work like a standard Excel-defined function?

Thank you in advance for your assistance.

[mdmackillop]

Put the functions in a standard module in a new workbook and save it as an Excel add-in (xla) file. Make it available from the Tools/Add-ins panel.

[kualjo]

That did it! Thanks!