N nore Dec 29, 2007 #1 how to make a custom function(vb script) available globally (as in used from every workbook, without having to add the module manually)
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 Dec 30, 2007 #2 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
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
