how to make a function(vb script) global (as in used from every w.

N

nore

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

Peter T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Global/Public/Universal variables 8
How to call module function or sub from the Add In? 3
functions in 'personal.xls' 4
personal.xls 2
Refresh Bloomberg data in an excel file from a script 4
Call API from vbscript via excel. 3
send sub routine variable to global 2
Custom Function Add-In not working 4

Top