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 ...
They worked reliably enough until recently for what I use them for which is generally to display and hide text boxes. I find this useful as you can display text to explain what a workbook/worksheet is doing/what it is for/how to sue it etc. and then hide the text so that it doesn't obscure the data. I don't know of another way to do that. I guess an ordinary button may work, but, as I say there is a snag to using them - which may be that I'd just have to edit all that worksheet vba I have. What a pain.
As far as I know, regular shapes mostly behave themselves. You can assign macro's to a shape too, so it might fit your need?
- Maybe, I did look into it before and as I say there was a snag, I can't remember what it was, - I don't have time to look into it again right now - but, if, as you say, MS have now broken activeX controls and are unlikely to fix them, then I'll have no choice but to try that eventually.
- I'm not aware of any recent change to the working of ActiveX controls. There was a problem a couple of years ago, that I do know. Try clearing your temporary files, especially files with the .exd extension must be deleted from your temporary folders.
- Mmm, well, I labour under corporate lockdown, as do many, of course I could raise a ticket to get these cleared, if there are any (I can't even look). Maybe I will. Thanks.