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