Macro execution via the RIBBON has stopped.

[Mackeral]

Now I get a message that says

Cannot run the macro "XXX".  The macro may not be available in this workbook or all macros may be disabled."

I know the macro works because I can run it out of VBA <macros> and it ran it all worked of the Ribbon a few hours ago. So that leaves "Macros Disabled" as the problem. But I've gone thru all the things it says to do from the web, and I still can't get the darn things to work again. And this is in production code I have to use.

Went of Office 365, but whoever I spoke with could only suggest I pay $99.00 for "expert" advice.

Any ideas of how to get around this?
Many thanks,
Mac</macros>

 

[footoo]

Try re-assigning the macro to the button.

 

[mole999]

I will presume you have done a full computer shutdown and restart, and that in the options, the Trust centre still allows macros

 

[Mackeral]

Solved: Macro execution via the RIBBON has stopped.

Instant fix.

Thanks so much for your reply.

Mac

 

[Mackeral]

Not SOlved: Macro execution via the RIBBON has stopped.

Restarting Windows 10 worked a couple of times, but now it doesn't work at all.

When I put "MsgBox "Activate" in a sheet's SelectionChange macro, it works. So macros are working at that level. But when I try to execute a Macro thru the Ribbon, I get the original error message "Cannot run the macro. The macro may not be available in this workbook or all macros may be disabled."

And restarting Windows doesn't make it work now.