Excel Active-X button cannot be clicked

Question

I have a button that should be clickable in excel. When I try to click it, nothing happens. I have noticed that if I click and hold the mouse in the lower right hand corner, a second button appears. This has happened in the past, and when I moved the mouse to click that button, I could click and everything would work.

But this time, when I move the mouse, the button goes away. Thus, I cannot make the program work.

Anyone know what could be going on?

UPDATE: I tried to do this with a form control button, but I get the error that the macro is too complex. I have also tried several other active-x controls and they all do the same thing - label, checkbox, dropdown list, etc... Any help with the active-x controls would be greatly appreciated.

Answer 1

I found a solution to the issue. It appears that if you have the excel file open on an additional monitor (I have 3 screens: main + 2 additional), the button gives this quirky behavior. However, if you are the main screen, it works just fine.

I tried this on multiple computers and it was the same on all.

Not sure why that works, but it does for me.