Hello Forum

First of all let me say the following is functioning brilliantly in Excel 2010 and have been for many years. However we have recently updated to Excel 2013 (and 2016)...

I have a couple of add-ins which I share in my office. The add-ins are created so that every user of one of the add-ins has an add-in of the AUXILIARY form installed which then call the ACTUAL add-ins. This solution is chosen to make sure that the ACTUAL add-ins are opened as read-only and most importantly so that I can easily make changes to them while in use.

Now here is the problem: In Excel 2013/2016 this method is very unstable and does not work at all when existing workbooks are opened (does work however when a new instance of excel is opened.... very weird). The ACTUAL add-in IS opened but somehow the Auto_Open (in the ACTUAL ADD-IN) is not functioning properly which means the user does not see the add-in on the ribbon. What is VERY WEIRD and frustrating is that when I debug the code I can see that the Auto_Open (again in the ACTUAL ADD-IN) is triggered but when i run it (Auto_Open) nothing happens and it drives me mad.
BUUUUT let's say I open an existing workbook of excel with the AUXILIARY add-in installed no add-ins appear on the ribbon. If I then go to the VB Editor I can clearly see the ACTUAL ADD-IN opened and when I run the Auto_Open of the ACTUAL ADD-IN it appears on the ribbon.
So to sum up: Somehow the code of the Auto_open in the ACTUAL ADD-IN is ignored by VBA in Excel 2013/2016 and I simply do not know why

Thank you for any help I may receive.

All add-ins are of the following form:

AUXILIARY ADD-IN:
Please Login or Register  to view this content.
ACTUAL ADD-IN (called by the auxiliary add-in):
Please Login or Register  to view this content.