Custom Function Add-In not working

  • Thread starter Thread starter Allen Geddes
  • Start date Start date
A

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!!!!!
 
Does anybody have any ideas why my custom function won't work from a module
in an add-in?? Thanks!
 
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!!!!!
Click to expand...

What happens when they try to use the function?

Could there be an issue with their security settings.
--ron
 
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!
 
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!
Click to expand...

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