Support Request: On load check if Addon is Installed if yes, skip CustRibbon UI load.

Experts,

After I’ve been thinking about it in my head and trying different codes, I cannot achieve my goal. I therefore need your experience & Support!

Let me explain:

I have an Addin that loads when I open excel addin name: "AddinX" and I have a book called "BookY" which has exactly the same Ribbon UI and macros as the Addin.

The question here is: How can I skip the load of the "AddinX" Ribbon UI & macros when I open the BookY, in order to load BookY macros and Ribbon?

Any suggestion its very welcome!

Originally Posted by Greg M

Hi there,

See if the following code does what you need - it should be placed in the "ThisWorkbook" VBA CodeModule of workbook "BookY":

Please Login or Register  to view this content.

The highlighted value may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Thanks!

With your suggested code I can do what I need, just small modifications on your suggestion to adjust to specific needs.

I appreciate your awesome support and easy solution.

Topic Solved 😊