My user defined function doesn't show up in autocomplete

[wlan]

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:

\1

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. How can i fix it? I want the autocomplete feature to work for my custom function. Please help. Thanks.

[pike]

Earthling Have a look here
http://www.excelforum.com/excel-2007...workbooks.html

[wlan]

it worked, thanks! but the .xlsb file shouldn't be set to "hidden".

[pike]

I think it dose mention that in the thread , but if not yes it should