AddIn spreadsheet function does not appear in dropdown list when entering function

Hallo Guys,

I created a custom spreadsheet function in Excel 2007. When I started typing it in a cell on a spreadsheet, a dropdown list appears with all the function names that start with the same letters. Then I could save time by selecting my function from that list without having to type out the whole name.

Then I turned the workbook that contained the function into an AddIn. Now I can use the function in any workbook, but, unfortunately, the function name does not appear in the dropdown list anymore. I have to type out the whole name to use it. The function does appear in the Insert Function dialogue box.

Any ideas on how to fix that?

Thanks.

Cross-postings:
http://www.xtremevbtalk.com/showthread.php?t=301720
http://www.vbaexpress.com/forum/showthread.php?t=23143