PC Review


Reply
Thread Tools Rate Thread

Adding a custom function to the default excel function list

 
 
DonutDel
Guest
Posts: n/a
 
      21st Nov 2003

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

 
Reply With Quote
 
 
 
 
BrianB
Guest
Posts: n/a
 
      21st Nov 2003

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

 
Reply With Quote
 
Tom Ogilvy
Guest
Posts: n/a
 
      21st Nov 2003
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" <(E-Mail Removed)> wrote in message
news(E-Mail Removed)...
>
> 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/
>



 
Reply With Quote
 
DonutDel
Guest
Posts: n/a
 
      21st Nov 2003

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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding the Custom Function to a Crystal Report harshad Microsoft Dot NET 0 23rd Feb 2010 12:28 PM
Error when adding custom help file to custom function Sabotuer99 Microsoft Excel Programming 1 19th Jul 2008 01:46 PM
Excel 2007 problems adding help file to custom function Sabotuer99 Microsoft Excel Crashes 1 19th Jul 2008 01:45 PM
Adding IF statement to custom function (VBA)? theseandavis@gmail.com Microsoft Excel Programming 3 11th Oct 2006 11:02 PM
Re: Custom Function - Adding Help Information Tom Ogilvy Microsoft Excel Programming 0 14th Apr 2005 03:47 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:48 AM.