Referring to function in another workbook
 

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

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

--
Regards,

Peo Sjoblom

(No private emails please)


"psp" wrote in message
...
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.
--