Adding a custom function to the default excel function list
 

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
:

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Adding a custom function to the default excel function list
 

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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Adding a custom function to the default excel function list
 

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 Long

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

Regards,
Tom Ogilvy



"DonutDel" wrote in message
...

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Adding a custom function to the default excel function list
 

Awesome! Both methods work nicely, Cheers guys :

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com