Even if the addin shows as installed, you still need to be sure that the
addin is opened else it will return the error message.

--
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
"Leo Lin" wrote in message
...
Hi,

I have a worksheet that previously use VBA function. Now I port the vba
funtion to xll function. so I remove the vba module and load the xll as
add-in. All the functions are well exposed in the "Demo" category when I
click the "paste function" icon. However, when I use the function in my
spreadsheet, for example, type "=MyFunc(a1)" at cells(2,2), I got #NAME?
instead.

Can anyone tell me how to make it work?

Thanks.

Leo