Forum Discussion
Macro buttons not working
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?
- 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"
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.
