Addin with workbook_open

Question

I have a number of addins that I have set up with Workbook_Open code to add an icon or icons to the ADD-IN section of the ribbon.  They've worked perfectly for ages.

I have a new laptop and have been running through the process to replicate the setup and each of the relevant addins is now stubbornly refusing to successfully run the Workbook_Open code.  The code works perfectly when selected AFTER the addin has been loaded, but it has always, previously, run automatically.

I must have a setting somewhere that I've missed and it's extremely frustrating.

Answer 1

Make sure you have enabled events:

Sub CheckAndResetEvents()

    If Not Application.EnableEvents Then

        MsgBox "Events were off, but I'm fixing it now!"

        Application.EnableEvents = True

    Else

        MsgBox "Events were on, so there is something else going on..."

    End If

End Sub