making a function usable in every sheet

[Guest]

I have a function that I'd like to be able in every file that I open or in
every file that I create going forward. I think it has to do something with
embedding it as my personal.xls template. Any ideas? Thanks in advance.

 

[Guest]

You can save the file which contains your function as an .xla file and then
add it to excel as an add-in

 

[Guest]

nice. thanks.

You can save the file which contains your function as an .xla file and then
add it to excel as an add-in

 

[Nick Revak]

I have a function that I'd like to be able in every file that I open or in
every file that I create going forward. I think it has to do something with
embedding it as my personal.xls template. Any ideas? Thanks in advance.

You can also record a macro and save it in your personal.xls workbook
and that will make the macro available in any other workbook that you open.

 

[K Bare]

I'm not entire certain, but apparently, subs in the personal.xls workbook can
only be run in other workbooks. If a custom function is to be available it
needs to be stored as an xla. And just saving it as an xla doesn't make it
available. Once the add in is saved you need to activate it by opening the
add in dialog from TOOLS>ADDINS and checking the box beside the add you just
saved.

So, I think the steps are:
1) create spreadsheet with the custom function
2) save it as an .xla (Excel Add In),
for example: MyNewFunctions.xla
3) navigate to TOOLS>AddIns and click the box beside
MyNewFunctions