Adding a custom function to the default excel function list

[DonutDel]

I've created a custom function, will it be possible to add this functio
to the default list of functions in excel ... so that the new functio
is avaliable every time excel is opened, regardless of what workbook
:

 

[BrianB]

The usual way is to put it in a (hidden) workbook in the XLSTART folde
so it opens when Excel opens

 

[Tom Ogilvy]

If you put it in an addin and the addin is loaded, it will appear in the
category "User Defined" functions

for more control, see this addin provided by Laurent Longre:

http://longre.free.fr/english/index.html#FunCustomize

Regards,
Tom Ogilvy

 

[DonutDel]

Awesome! Both methods work nicely, Cheers guys :