I have created workbooks each with an identical module containing 5 functions. Since I am using it over and over I decided to just turn the module into an Add-In. The Add-In works fine when I start new workbooks (which don't contain the module) and use the functions, but when I try to delete the module from the old workbooks it doesn't recognize the functions.
I have found that if I type in the Module name within the Add-In that was created before the function name, it works properly (e.g. Module1.Function1(...) instead of Function1(...)). Is there any way to refresh the function calls in the old workbooks so that they know where to look for the function? Thanks!
I have found that if I type in the Module name within the Add-In that was created before the function name, it works properly (e.g. Module1.Function1(...) instead of Function1(...)). Is there any way to refresh the function calls in the old workbooks so that they know where to look for the function? Thanks!
