VBA for add-ins

[blcexcel]

I use an Excel Add-in that drops off the menu every time I close Excel. It is very annoying. I would like to create a macro that will add the add-in automatically when I start Excel. Specially it drops the com add-in. The Record Macro doesn't capture the steps of adding the add-in. Any help would be appreciated. Thanks in advance!

 

[Hui]

Have a read of these posts to see if it helps you?
https://support.microsoft.com/en-ph/help/291392/excel-com-add-ins-and-automation-add-ins
&
https://support.netdocuments.com/hc...ing-the-Load-Behavior-of-the-ndOffice-Add-ins

Obviously adjust the setting that refer to your specific addin

 

[blcexcel]

Thanks! I like the tip in the document about adding a menu option to the Quick Access Toolbar. I'm going to go with that option.