Cannot run macro using customUI Ribbon buttons

[MarshmallowMatie]

I have a workbook add-in saved as 'Generate Report.xlam' that I want to automatically generate reports. I have all of the code for that in the UserForm objects. I have managed to get this setup working with a customUI RIbbon and buttons that call subs in the ThisWorkbook object which open the UserForms but for some reason after changing something that I do not quite remember it gives me this error:

My Add-In Project contains:

In the ThisWorkbook code I have:

My XML for the customUI is:

I used Office RibbonX Editor to inject the XML into the Add-in. I have enabled all macros in the settings and set the current add-in's location to a trusted location in the Trust Center.

If anyone could help resolve my issue of my UserForms not opening that would be much appreciated. (On an unrelated note just to make it look cleaner is there anyway to remove the sheet objects to the add-in)

 

[Domenic]

It looks like you've set it up correctly.

Your XML code looks fine. You've qualified the onAction reference to your macro with ThisWorkbook. So that's good.

And your VBA callbacks look fine as well.

So if you've enabled macros, it should work.

By the way, in future, instead of posting code as images, please post them between code tags. This way we'll be able to easily copy and paste the code for testing purpose. You can find the button for code tags just above the text area when posting.

 

[MarshmallowMatie]

Thanks for looking into this Domenic and for the advice for future posts.

I've realized that the file must have not been compiling because I added an assignment of a variable outside of a sub

It's always the stupid mistakes that get you.