Feb 13 2019 04:48 PM
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 the macro runs; however, the buttons themselves are completely non-responsive. I can run macros successfully from the quickaccess toolbar.
May 22 2019 03:48 PM
Hi, I have exactly the same problem as this. Did you ever find a solution for this.
Jun 02 2019 09:53 AM
@Ramsay119I am also having this problem. I find that rebooting fixes it temporarily but then it comes back at unexpected times. I would like to determine what triggers the problem, but I haven't had much experience with this problem yet.
Jul 12 2019 07:16 AM
@DeniceAP123 I am having the same problem and I found that double clicking the button works.
Jul 23 2019 05:33 AM
@DeniceAP123 the buttons do not work when I have my two screens in extended display but when I change the display to duplicate it does work. It has something to do with the screen resolution from my understanding. Maybe you can try that...
Jul 24 2019 09:24 PM
Jul 28 2019 04:34 PM
Jan 06 2021 02:01 AM
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 the macro runs; however, the buttons themselves are completely non-responsive. I can run macros successfully from the quickaccess toolbar.
I have the same problem, have you found a solution ?
Send your answer to h.k.devor@zonnet.nl or whattsapp +31621254976
Jun 16 2021 02:08 AM
Aynen ben de hiç bir makro butonum çalışmıyor. Office'i tamiri denedim yine olmadı. Microsoft çözüm üretene kadar aradan yıllar geçer. 2021 Hazirandayız.
Jun 17 2021 04:25 PM
Encountered the same problem. I have macro buttons that will work when viewed on my external monitor but not when on the laptop monitor. I'm guessing it's something to do with resolution, scaling and mapping of clickable zones not working right. No idea what the fix is other than to use my external monitor for this workbook.
Jul 11 2022 03:19 AM
Nov 13 2022 06:18 PM
we have same issue, the laptop in office with 2 extension monitor having issue with excel button and others with 1 extension monitor works fine.
thanks for sharing the tip, we will never link this issue with display setting myself.
we set all monitor with same scale (125%) and the button work again.
Apr 06 2023 09:55 AM
Jul 11 2023 05:42 AM
@DeniceAP123THEY MAY ONLY WORK ON THE PRIMARY DISPLAY. I ran into this thread looking into issues with someone not being able to use the button macros. Just move excel to your primary display, kinda crazy.
Jul 21 2023 07:01 AM
Aug 09 2023 02:15 AM
Sep 07 2023 12:25 AM
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?
Dec 12 2023 12:03 PM
Dec 13 2023 12:21 AM
@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.