Macro buttons stopped working in Excel

[zebra7860]

Hi,

Every few months, the macros that were created for me by a friend, and which have been a great help to me, stop working.

This morning, I clicked on something, perhaps a cell between the buttons and saved it too quickly, and now when I move my mouse
over the buttons, it no longer just has the cursor, but a "+" at the end of a cursor, and the buttons no longer work.

There has to be quick fix to this.

Please help
Thanks
Al

 

[ranman256]

make sure the excel app still has vb code. Saving to some formats will erase the code. (.xlsx)
make sure your macros are enabled. File,options, Trust, trust center settings, macros, enable macros.

 

[zebra7860]

thanks

 

[capn_k]

I am having a similar problem. the Macro Buttons worked for years and have stopped. I cant find any method to turn them back on. Any help would be great.

 

[PowerDF]

Hi,

Every few months, the macros that were created for me by a friend, and which have been a great help to me, stop working.

This morning, I clicked on something, perhaps a cell between the buttons and saved it too quickly, and now when I move my mouse
over the buttons, it no longer just has the cursor, but a "+" at the end of a cursor, and the buttons no longer work.

There has to be quick fix to this.

Please help
Thanks
Al

Functionality of macro buttons are often affect when monitor/display are re-sized. For example, from 100% to 125%. This resizing rendered all my Active X Command Buttons from executing the VB code. The worksheet simply becomes inactive and must me clicked on to come back to active mode. Macros will work only if you manually run them.
When I resized my monitors back to their “recommended” settings, the functionality of the Active X buttons were restored.

 

[stuefi]

my activex button some stopped working, after countless hours of researching: excel somehow change the reference for the "click"-button - it somehow appended the german word "Klicken" - changing that back to english did the trick.
cheers