ActiveX command button not enabling

[Pookiemeister]

I have an ActiveX command button on my spreadsheet which when the user presses it, it opens up a userform. The code was written in Excel 2010 but is used on a machine at work running Excel 365. When I first used this file on my work computer it worked as expected but now for whatever reason, the button stopped working and the caption is greyed out. There is no change in the code. Also, sometimes before it did this, if I were to run this file on someone else's computer when I used to click the button it would resize the button but that might be because of their screen resolution but as I stated before, it originally worked. I know if I delete this button and recreate it and named it the same as what is in the code, it works again. But why does it act this way? Thank you for any help offered.

 

[RoryA]

ActiveX controls on worksheets are prone to this bug (and others). Excel stores temp files for activex controls (.exd files) and a difference in versioning of the library for an object can cause them to stop working completely (and also cause weird random code errors). Unless you really have to, use a Form control rather than ActiveX.

 

[Pookiemeister]

WOW! Thank you. I did not know that.