Issue with UDFs in Personal Addin
 

I created an addin at work that I store on our shared server. I found that
this allows mutliple users the ability to use the macros and have the code
and custom toolbars automatically update each time Excel is opened.

I wrote a few UDFs that I want to include in this addin. They worked fine
in my test spreadsheet that was stored on the server; however, when I moved
the module to the addin, they no longer work when called. Each function is
available under the Insert- Function command, but each test of the function
results in a #NAME? error.

I did some research and found a forum here by JodieM who had issues with
UDFs in custom addins on servers. A suggested solution was to copy the addin
to the user's local folder. I do not wish to do this because I frequently
update and add to the addin's code and need it to refresh for each user.
Also, I tried copying the addin containing UDFs to my local addins folder,
and the sheet STILL returned a #NAME? error when asked to use the functions.

Can anyone explain what's going on here and suggest a solution? Thanks,
Pflugs

Issue with UDFs in Personal Addin
 

is you r UDF declared as Public?
--
Pranav Vaidya
VBA Developer
PN, MH-India


"Pflugs" wrote:

I created an addin at work that I store on our shared server. I found that
this allows mutliple users the ability to use the macros and have the code
and custom toolbars automatically update each time Excel is opened.

I wrote a few UDFs that I want to include in this addin. They worked fine
in my test spreadsheet that was stored on the server; however, when I moved
the module to the addin, they no longer work when called. Each function is
available under the Insert- Function command, but each test of the function
results in a #NAME? error.

I did some research and found a forum here by JodieM who had issues with
UDFs in custom addins on servers. A suggested solution was to copy the addin
to the user's local folder. I do not wish to do this because I frequently
update and add to the addin's code and need it to refresh for each user.
Also, I tried copying the addin containing UDFs to my local addins folder,
and the sheet STILL returned a #NAME? error when asked to use the functions.

Can anyone explain what's going on here and suggest a solution? Thanks,
Pflugs

Issue with UDFs in Personal Addin
 

No, they weren't. They are now, and everything seems to be working fine, no
matter where the source addin is saved.

That's a huge relief. Thanks very much for pointing that out.
Pflugs

"Pranav Vaidya" wrote:

is you r UDF declared as Public?
--
Pranav Vaidya
VBA Developer
PN, MH-India


"Pflugs" wrote:

I created an addin at work that I store on our shared server. I found that
this allows mutliple users the ability to use the macros and have the code
and custom toolbars automatically update each time Excel is opened.

I wrote a few UDFs that I want to include in this addin. They worked fine
in my test spreadsheet that was stored on the server; however, when I moved
the module to the addin, they no longer work when called. Each function is
available under the Insert- Function command, but each test of the function
results in a #NAME? error.

I did some research and found a forum here by JodieM who had issues with
UDFs in custom addins on servers. A suggested solution was to copy the addin
to the user's local folder. I do not wish to do this because I frequently
update and add to the addin's code and need it to refresh for each user.
Also, I tried copying the addin containing UDFs to my local addins folder,
and the sheet STILL returned a #NAME? error when asked to use the functions.

Can anyone explain what's going on here and suggest a solution? Thanks,
Pflugs