Hi!
I have created a VB function in a workbook and would like to use the same
function in other workbook (not worksheet). Ideally, I would like to copy it
somewhere in the workbook so I can refer to it as locally without referencing
other workbook. The application I have uses a template workbook that I copy
each month to create a new one.
thank you,
Prashant.
Peo Sjoblom - 31 Aug 2005 22:32 GMT
Make an add-in (save as add-in *.xla), then check the name of the add-in
you created under tools>
add-ins)
http://www.mvps.org/dmcritchie/excel/install.htm#addin

Signature
Regards,
Peo Sjoblom
(No private emails please)
> Hi!
>
[quoted text clipped - 10 lines]
>
> Prashant.