I don’t use user defined functions in add-ins all that often, but I happen to have a particular add-in with one UDF. And I happened to have recently moved that add-in. And all my links happen to be broken.
Fortunately, Jan Karel has an exhaustive write-up on how to fix and prevent this problem. Go to FixLinks2UDF.
John Walkenbach, in Power Utility Pak, copies the UDF to the workbook in which it lives. I think that’s perfect for a general purpose utility, but it goes against my rule of keeping code and layout separate. If I change the UDF, it won’t be changed everywhere. I could make the argument that it shouldn’t change for previously created reports, but I just don’t know.
In this add-in, I already capture the opening of reports, so I suppose I’ll just update the links as they’re opened. In any event, I hope this link love kicks JKP’s article higher on Google so I don’t have to search so hard for it next time.