=Personal.xls!Myfunction(arg1,arg2)
the workbook with the UDF must be open.

Or copy the UDF to the workbook where you want to use it.

--
Regards,
Tom Ogilvy

"JohnDing" wrote in message
...
How to use User-defined-functions in other workbooks other
than saved "xla" files.