Forum Discussion

DeniceAP123's avatar
DeniceAP123
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
jogin38's avatar
jogin38
Copper Contributor
Jul 23, 2019

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

 

 

 

 

  • ihebth's avatar
    ihebth
    Copper Contributor
    Aug 09, 2023
    Absolutely right, even when I have extended screens, I just have to drag the file to the Laptop's screen and click on the buttons and it works.
    I tried putting it back on the extended screen and it stops working immediately.
  • Liborme's avatar
    Liborme
    Copper Contributor
    Jul 21, 2023
    jogin38 - this solved the problem for me! Thank you 🙂
  • Proactive_eng's avatar
    Proactive_eng
    Copper Contributor
    Jul 11, 2022
    yes, my problem was solved. when I moved the excel windows to the first monitor. it is rediculous
  • Ramsay119's avatar
    Ramsay119
    Copper Contributor
    Jul 25, 2019
    jogin38, thanks this worked for me, disconnected laptop from dock and voila it works perfect. It also solved another Excel problem for me. When I print a chart that has been moved to a separate tab, it would only print about 2/3. When not docked it prints then entire chart.
    • Ramsay119's avatar
      Ramsay119
      Copper Contributor
      Jul 28, 2019
      Follow up, I am using a laptop with 2 monitors. The setup up is the monitors are at 100% scale and the laptop was at 150% (old eyes). When I change the laptop to match the monitors (100%) and restart everything works.

Resources