Spreadsheet functions, Add-ins and autocomplete lists

Hallo Guys,

In Excel 2007, I have made a custom spreadsheet function. When I start typing the function in a cell on a sheet, a list of functions that start with the same letters appears and then I can select my custom function from the list. This makes entering the function much faster, especially since the name of my function contains ten characters.

I have proceeded to save the workbook as an add-in, but have noticed, when I open another workbook and start typing the function name in a cell (after the equal sign, of course) the rest of the Excel functions that start with te same letters appear in the list, but not my custom function. However, I can still use my function in any workbook and it also appears in the Insert Function dialogue box.

How can I make my function appear in that list now that I have made the workbook that contains it into an add-in?

Thanks for your help.

bump