Forum Discussion
Issues with Excel ActiveX checkboxes
I do not have an answer for you, but you have solved a problem I have been having. As recently as June, I have been able to open a file with ActiveX buttons and they all worked correctly. As of this week when I tried to use the program, none of the buttons would do anything when I tried to click on them.
Yesterday I was working in my kitchen and tried again, on my laptop, and they worked! I just tried again today in my office that has two external monitors, and nothing. I searched for an answer, saw your dilemma, and poof! I can now use the ActiveX controls, but only if the file is on my laptop and not on my external screens.
This has to be some sort of update that Microsoft has made between June and now, since I know that I have been able to use those buttons in this exact file on the external screens in June.
Hope narrowing down the timing of the issue is helpful in your search for an answer.
- Seasand, I may have found just the fix for you! Go to File > Options > General in Excel, and under User Interface Options, select "Optimize for Compatibility". The issue was due to the scale of the specific monitor you were on, and that fixes it.