User defined function not recognized
 

I have two user defined functions saved in my
personal.xls. One of them works fine in any workbook. The
other returns #NAME? when I use it till I copy the code
from personal.xls and save it to the workbook i am working
in at the time. In personal.xls the code for both
functions is saved on the same page. Any suggestions?
Thanks

User defined function not recognized
 

Would like to see the code behind the udf's.
My first check woul be to see if the udf calls another
function that's not referenced by personal.xls

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
I have two user defined functions saved in my
personal.xls. One of them works fine in any workbook.
The
other returns #NAME? when I use it till I copy the code
from personal.xls and save it to the workbook i am
working
in at the time. In personal.xls the code for both
functions is saved on the same page. Any suggestions?
Thanks
.