making a user-defined function accessible to all workbooks

[dpolson]

I've got a couple of user-defined functions that I coded in via one workbook (wkb A), but would like these functions to be accessible to any workbook (wkb B...Z). How is this done so that when I start a new blank wkb I can use these user-defined functions there as well?

 

[jkmjalam]

Thanks from me too Ricky!

Yogi Anand

"Thanks from me too RICKY !!!

 

[jkmjalam]

Save the file with the function with an xla extension. This will tell Excel that it's an add-in workbook. Then Select Tools > Add-Ins from the menu and browse to the xla file you saved. The function will now be available to all workbooks in Excel.

Thanks Ricky , you solved my problem... -jkmjalam

 

[rtchan]

Hi Jay:
It worked with the ! preceded by the name of the workbook.xls -- I did not need to enclose the name of the workbook in []s.

THANKS!

Hi,

I tried workbook.xls!MyFunction(arg1,arg2) but it doesn't work!

Any help is appreciated.

 

[basb87]

many years later: Thanks from me too, Ricky!

Thanks from me too Ricky!

Yogi Anand