My user defined function doesn't show up in autocomplete
Hi, I have created a user defined function (custom function) with Visual Basic Editor (alt + f11) in Excel 2007. I clicked "Insert Module", and written the function code, and saved it. The name of the function is: "ConCatRange" (i didn't write this function myself, i copied it from internet). In that workbook, when i type the first few letters of the function name, the autocomplete works very well, like:

http://yfrog.com/1539058535j

but i want to make this function available everywhere, not only in that workbook but in every excel file. So i saved this function as an "add in" and made it available in Excel Options.
Now i can use this function in any workbook, but when i type the first few letters of that function in other workbooks, it doesn't show up in the autocomplete menu.

I also recorded the macro in Personal.xlsb file, and i put the file in XLSTART folder. When i open a new workbook, my user defined function works, but again, it does not show up in autocomplete drop down menu. Personal.xlsb file is not disabled in the Excel options-> add-ins-> manage-> disabled items. I mean it is enabled.

How can i fix it? I want the autocomplete feature to work for my custom function. Please help. Thanks.