Forum Discussion
ActiveX buttons unresponsive or having to be clicked twice to run macro
Hello, community!
I inherited two Excel files that come with a bunch of ActiveX buttons.
In some cases the buttons don't do anything: I click them, it shows kind of a duplicate image of the button on the side when I press the button, but nothing happens. The macro associated runs well if I run it from the VB Editor.
On the other file, the buttons do work but only when I click them for the second time. Any idea what may cause this to happen?
Thank you in advance for any tip or guidance.
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 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.
PratikAngaj This works perfectly for me. Thank you very much for sharing
- Thank you! I had a new workbook and found the same issue with my buttons. Your solution worked perfectly.
- Hard to say without the file. ActiveX buttons do cause havoc at times, perhaps replacing them with forms buttons helps?
- Hi Celia,
I've just started having this issue - on my old laptop it was only one click to make the buttons work, but now on Windows 10 it takes a double-click to make them work? So strange, never seen this before.
Just wondering if you ended up finding the issue?
Cheers- Hi, _Ness_.
Unfortunately, I did not find the cause or a solution.
If I remember, I think that in one of the cases, deleting the button and creating a new one, helped. I am not sure if I replaced it with an active x button or one of the other button types.oi tudo bem Celia_Alves I have this issue too. I don't think it's W10 per-se as they were fine until recently - so it's something to do with a recent update I would say. I did look at replacing them with ordinary buttons but there was some disadvantage to that - which I can't recall right now. I'll try the "delete and replace with new" approach to see if that works, though, even if it does, it's hardly satisfactory. I don't recall a recent update coming with a disclaimer from MS saying that activeX macro buttons may not work (properly) anymore (mind you I expect what the small print actually says is that if their update causes Armageddon it's still not their fault!).
