Forum Discussion

Copper Contributor

Feb 14, 2019

Macro buttons not working

Hi, when I try to run a macro using its buttons, the buttons do not respond, animate, or function. Often a box will hover above the button containing its text, and when I am able to click on the box ...

Macros and VBA

Guido_Busuttil

Copper Contributor

Sep 07, 2023

I have a slightly different variation. I have 4 buttons and only one decided to not work. I tried all of the other options, as I have 2 monitors and a docking station.

If I run the macro manually it works, but not through the button.

I tried Removing the docking station, that did not help. I then thought to try and rename the macro, reassigned the new name to the button and it worked. Maybe some one technical can offer an explanation as to why this happens?

LTNguyen

Copper Contributor

Dec 12, 2023

This worked for me too. Renaming the subroutine, reassigning the macro, then going back to the subroutine name I prefer solved my issue. I tried everything else mentioned in this thread but this is like a "reset"

Guido_Busuttil
Copper Contributor
Dec 13, 2023
LTNguyen Yesterday I compiled a few macros which I try and name as close to what they do as possible. The problem with this is the name of the subroutine becomes very long and I noticed that the buttons were not responding but running the app from the code was still possible, I then reduced the name length by abbreviating words in the sub name and then I reallocated the button and it worked. what I have resorted in doing is, to create the sub name as short as possible but then commenting below the sub, describing what it does and where it is applicable in the workbook as well as, if the sub was working or not.