UDF Availability

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

I have developed a UDF (user defined function)in one
workbook. Is there a way that I can make this UDF
automatically available to any workbook used? (instead of
copying and pasting to every workbook.)

Thanks
 
If you put it in your Personal.xls workbook, or any other workbook
that is in the XLStart folder, it will be available. Call it with
the name of the workbook:

=Personal.xls!foo(bar)

If you put the function in a workbook and save the workbook as an
add-in, you won't need to prefix the workbook name (unless there are
duplicates).
 
Back
Top