User defined function

  • Thread starter Thread starter linzhang426
  • Start date Start date
L

linzhang426

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.
 
Yes. If you save your UDFs in your personal.xls they will be available
whenever you use Excel
 
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)
 
Put your code into a module in a new workbook, "Save As" the workbook as an
add-in, hide the workbook (Window / Hide), and then use Tools / Add ins...
and set the workbook as an add-in. Then you can use the UDF without
preceeding the UDF name with the name of the workbook, like personal.xls....

HTH,
Bernie
MS Excel MVP


"linzhang426" <[email protected]>
wrote in message
news:[email protected]...
 
Thanks a lot for your help for my UDF question, Gents. I will give a tr
to see if it works. I am sure it will though
 
Back
Top