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!


"Allen Geddes" wrote:

> 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!!!!!

On Thu, 13 Nov 2008 19:22:13 -0800, Allen Geddes
<(E-Mail Removed)> wrote:

>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

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" wrote:

> On Thu, 13 Nov 2008 19:22:13 -0800, Allen Geddes
> <(E-Mail Removed)> wrote:
>
> >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
>

On Mon, 17 Nov 2008 16:56:00 -0800, Allen Geddes
<(E-Mail Removed)> wrote:

>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