If your add-in with the functions is properly loaded, your UDF's should show up
under User Defined category.

That category will be at bottom of Insert Function list.


Gord Dibben MS Excel MVP

On Tue, 13 Jul 2010 08:53:22 -0700 (PDT), K wrote:

Hi all, I have created a functition called "SUMCOLOR" in vba and when
I checked in excel cell it was listed in existing excel functions.
But when I saved that workbook in which I created that function as an
excel adding and after installing that Addin when I tried using that
function in other workbooks, the function was working but its not
listed anymore in existing functions list. Please can any friend tell
me that why is that. Basically i have created a function and i want
to use it as Addin and i also want it to appear in excisting functions
list so user will know that there is function called "SUMCOLOR"