Forum Discussion
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 ...
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.