Forum Discussion
ActiveX buttons unresponsive or having to be clicked twice to run macro
Celia_Alves I had the same problem and I solved it by changing the display setting.
on the excel status bar > Display Settings> choose : optimise for compatibility.
issue will resolved.
PratikAngaj Love U, thanks a lot.
Excellent! This improved the behavior a lot. Still, for the ActiveX button to work on the first click, the excel workbook has to have focus already. Otherwise, the first click changes the focus to excel and the second click runs the ActiveX macro. It looks like by disabling 'best appearance' we lose just that: the worksheet appears not at its best. So, it's a bit of a trade-off.
Solution of PratikAngaj works also for me, but I really don't like the degraded look of the worksheet.
Another solution I found is to modify the name of the macros in the VB editor (Alt-F11), so as to use the "MouseUp" event or "MouseDown" event, instead of the "Click" event.
For each control:
- replace the "ControlName_Click ()"
- by "ControlName_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
No more trade-off 🙂
Maybe it is also possible to add something to the Class, but I'm not sharp on this.
I preferred to use the _MouseUp() event, as you then will still have the visual effect of the button depressing whilst the event is being fired.
- Pratik's answer worked for me. No other change made. Thank you Pratik!
- Thank you! I had a new workbook and found the same issue with my buttons. Your solution worked perfectly.
PratikAngaj This works perfectly for me. Thank you very much for sharing
PratikAngaj That worked! Thank you so much.
HarveyWatson I don't want to beat a dead horse here, but it happened to me as well. I didn't see @pratikangaj response or I would've tried that first...
Anyway, I went to design mode, right clicked on the button and selected "Command button object", then "Edit". I didn't change anything, just clicked out of that and for some reason that fixed it.
The problem seems to have gone away for me now. Don't know if that's because I did the delete .exd files thing or because, perhaps more likely, MS have now fixed whatever it is they did to cause this in the first place.
