Addin Order in Registry

[dumitrudan608]

Hello,

I have this situation at my work place:
-there is an big add-in that is frequently being updated by someone else (uninstalls add-in and re installs it, and creates an excel menu so the users can handle the macros easier)
-i have been asked to create a separate add-in, but with references to the first one (like global formulas and variables)

The problem is when the main macro gets updated, my macro gets moved to the top of the order list in HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options the ones with OPEN1 ...

So the normal order is:
OPEN -Main Macro
OPEN1 -My Macro

If the main macro gets updated it will be moved to the bottom of the order list, and my macro that has references to the main macro will give the next error: "This workbook is currently referenced by another workbook and cannot be closed" each time you open Excel,

I am looking for a one click workaround this, a macro that will rebuild the order in the registry. So far the only ruff workaround this is each time the main macro gets updated i uninstall and re install my macro manually but for a non technical user this can be problematic.

I tried to mingle with on workbook open but it cannot override the main macro code, so it will not work.

Really hope someone can help me with this.

Kind regards,
Daniel