Macro execution via the RIBBON has stopped.

Mackeral

Board Regular
Joined
Mar 7, 2015
Messages
225
Office Version
  1. 365
Platform
  1. Windows
Now I get a message that says
Code:
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>
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
I will presume you have done a full computer shutdown and restart, and that in the options, the Trust centre still allows macros
 
Upvote 0
Solved: Macro execution via the RIBBON has stopped.

Instant fix.

Thanks so much for your reply.

Mac
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,255
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top