To add to my frustration with this, our IT department won't let us lower our security settings to low.
Your IT department is showing good common sense. You wouldn't do that at home, would you?
When a workbook references UDFs in an add-in, it creates hard-coded links to the location of the add-in, and moving the add-in (like from your computer to a network drive) breaks those links.
I think you can have your users 're-enter' the formulas (F2, Enter, and copy down), and things will be hunky-dory until IT moves the add-in.
The clean(er) solution is registering the functions. See http://www.jkp-ads.com/Articles/RegisterUDF00.htm
Edit: It may be the case that the simpler option of registering with MacroOptions works. In the ThisWorkbook module of your add-in:
I have not used the latter method. If you choose to try it, would you be so kind as to post back and let us know if it works for you?
Bookmarks