Hi Y'all,
I have written two excel functions for my project and wanted to make
them into an add-in so they're available for all my spreadsheets.
I followed the exact procedure and now have my functions appear as an
add-in.
However, only one function works!!!
It's the weirdest thing, both work fine when the module is part of the
workbook, but when in an add-in, only one function works, and the
other gives the #NAME? error.
I'm going nuts trying to figure this one out.

Any thoughts?

Thanks,
Jacek

Are both functions in regular code modules?

In article ,
(Jacek) wrote:

I have written two excel functions for my project and wanted to make
them into an add-in so they're available for all my spreadsheets.
I followed the exact procedure and now have my functions appear as an
add-in.
However, only one function works!!!
It's the weirdest thing, both work fine when the module is part of the
workbook, but when in an add-in, only one function works, and the
other gives the #NAME? error.
I'm going nuts trying to figure this one out.

Yeap,
Both are written in the same module. I even changed the order of
which was first in the module.
I figured it out though. The problem was that one function must have
had a reserved word within the name (but the whole name wasn't
reserved), as when I changed it it worked fine. The weirdest thing is
that it works from within the spreadsheet module, but fails when run
as an add-in.

Jacek

JE McGimpsey wrote in message ...
Are both functions in regular code modules?

In article ,
(Jacek) wrote:

I have written two excel functions for my project and wanted to make
them into an add-in so they're available for all my spreadsheets.
I followed the exact procedure and now have my functions appear as an
add-in.
However, only one function works!!!
It's the weirdest thing, both work fine when the module is part of the
workbook, but when in an add-in, only one function works, and the
other gives the #NAME? error.
I'm going nuts trying to figure this one out.

I figured it out!
The problem was that the UDF didn't work beacuse it had another
function name as part of it's name. Weird, but once I changed the
name to something else (with the same number of characters), it worked
fine.

Jacek

(Jacek) wrote in message om...
Hi Y'all,
I have written two excel functions for my project and wanted to make
them into an add-in so they're available for all my spreadsheets.
I followed the exact procedure and now have my functions appear as an
add-in.
However, only one function works!!!
It's the weirdest thing, both work fine when the module is part of the
workbook, but when in an add-in, only one function works, and the
other gives the #NAME? error.
I'm going nuts trying to figure this one out.

Any thoughts?

Thanks,
Jacek