If you mean a UDF (User Defined Function) written in VBA, if you place it in
an Addin it should be available to all workbooks.

Alternatively you can also put it in a normal xls and use it in a cell like
this:

=Personal.xls!myFunction(arg1, arg2)

Regards,
Peter T

"nore" wrote in message
...
how to make a custom function(vb script) available globally (as in used
from
every workbook, without having to add the module manually)