VBA Function not working when converted to an Excel Addin

[chaos24]

This question may have been posted before, but I'm new to this website and can't find the answer.

My problem is that I created a few functions in VB for Excel and these functions are used in multiple spreadsheets. Instead of updating the functions in all the spreadsheets when changes are made, I decided to put them into an add-in. I installed the add-in and removed the module on the spreadsheet, but now the spreadsheet just shows #NAME? when I call for that function. I can solve this problem by pointing the function to the .xla, but that can't be a long term solution.

='C:\test\ExampleAddin.xla'!NewFunction(x)

I don't want to keep pointing to the addin whenever i need that function.

Please help!!!


Frustrated in MI

 

[ETID]

is there a reference in the add in code that was broken when you moved it?

 

[chaos24]

I don't believe there was a reference that was broken in the add-in