Custom function

Hello everyone!

I wrote a custom function and I want it to work on any Excel file that I open.

How can this be done?

From an inquiry so far I understood that you can save as an XLMA file only that I could not

Thanks to the respondents

Hi,

The only way to do this is to save your file as XLAM, or please tell why you can't achieve this.

My mistake

Now I saved as an XLAM file.

Does the file need to be opened to use the function in other files?

I guess u can specify which folder to load files from at startup via the:

Advanced>General section of the Options dialog.

Also, any files stored here...

C:\Documents and Settings\user\Application Data\Microsoft\Excel\XLSTART

...will also be opened at startup.