Hello forum, this is my first post and I'm an excel newbie, so bear with me...
I created a complex excel file to be shared by several users.
It is using a special application by a third-party supplier that only certain users have it installed on their computers.
This means that the ones that don't have the application installed get the "Compile error in hidden module: XXXX. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application....." error.
I know I can create a code to disable the missing reference and not have to go to each user and disable it manually on each computer. However, I want the reference to continue like this on these users, I want to be able to bypass this error, because it's not important that the users that get the error don't have access to this third-party application.
I hope I've been completely clear on my problem and maybe someone could give me a hand on how to create a code to bypass this error. Essentially make it not appear, just that.
I'm using excel 2010.
Thanks!
Bookmarks