UDF Availability

[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

 

[J.E. McGimpsey]

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).