Add-in functions (some work, some don't)

  • Thread starter Thread starter Jacek
  • Start date Start date
J

Jacek

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
 
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
 
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
 
Back
Top