Custom Function Add-In not working

[Allen Geddes]

I wrote a custom function in a module, then saved the workbook as an Excel
2007 Add-In... I sent that Add-In to someone else who, and had them enable
the Add-In... The Add-In was successfully enabled, but they can't use the
custom function that I wrote.

They can go into the VBE, see the Add-In, see the module that the custom
function is stored in, and see the code for the custom function, but can't
use the function unless they copy the code from the Add-In Module to a module
in their Workbook.

Please help me figure out why the custom function isn't working from the
Add-In! Thank you!!!!!

 

[Allen Geddes]

Does anybody have any ideas why my custom function won't work from a module
in an add-in?? Thanks!

 

[Ron Rosenfeld]

I wrote a custom function in a module, then saved the workbook as an Excel
2007 Add-In... I sent that Add-In to someone else who, and had them enable
the Add-In... The Add-In was successfully enabled, but they can't use the
custom function that I wrote.

They can go into the VBE, see the Add-In, see the module that the custom
function is stored in, and see the code for the custom function, but can't
use the function unless they copy the code from the Add-In Module to a module
in their Workbook.

Please help me figure out why the custom function isn't working from the
Add-In! Thank you!!!!!

What happens when they try to use the function?

Could there be an issue with their security settings.
--ron

 

[Allen Geddes]

Thanks Ron, I figured out what the problem was... I had named the VBA
Project, Add-In, and Custom Function all with the same name. Apparently,
that was causing a conflict when I called the function by name... because
after changing the names of all of them to something different, the function
works perfectly!

 

[Ron Rosenfeld]

Thanks Ron, I figured out what the problem was... I had named the VBA
Project, Add-In, and Custom Function all with the same name. Apparently,
that was causing a conflict when I called the function by name... because
after changing the names of all of them to something different, the function
works perfectly!

I've run into that, also. But I would have thought you'd have trouble on your
own machine, also.
--ron