Cannot run a Macro from Quick Access toolbar or Ribbon

[cliffclayman]

I am using Excel 2010. I have created a macro in my PERSONAL.xlsb file that I am able to run if I go to Developer - Macros - Choose the macro name - Click run. However, if I add the macro to the quick access toolbar or the ribbon, nothing happens. I don't receive any error messages, the button just doesn't do anything. I don't have any restrictions on running macros through the security as I selected Enable all macros just to be sure.

 

[cliffclayman]

I tried a couple more things and I still had no luck. Anyone have any suggestions?

 

[Jerry Sullivan]

Hi Cliff,

A good first step would be to determine whether the macro is being triggered or not. One possibility is that macro isn't being triggered at all, the other is that it is being triggered but not behaving as expected.

Try placing a MsgBox at the beginning of the Macro....

Sub YourMacroName()
 Msgbox "Running my macro from personal.xlsb"

 '...rest of your code

End Sub

Also, please post the macro code.