if you put your UDF's in the personal macro workbook, I believe you will need
to precede the function name with the workbook name (personal.xls).

=Personal.xls!FunctionName(arg1,arg2,etc)


"linzhang426" wrote:


I wonder if there is any way for me to write an user defined function so
that everytime I open a new Excel spread sheet I can use it. Something
like internal function.


--
linzhang426
------------------------------------------------------------------------
linzhang426's Profile: http://www.excelforum.com/member.php...o&userid=27932
View this thread: http://www.excelforum.com/showthread...hreadid=474292