ActiveX objects stop working

I have a series of workbooks that each contain about 24 comboboxes, 24 checkboxes and 1 command button. In general they work fine, but periodically, all the controls in a spreadsheet will just stop working. It's almost like it's in developer mode, but they are not. With the one I'm having issues with this morning, the button & checkboxes are completely unselectable, nothing happens at all when I click on them. With the comboboxes, instead of dropping down with the list of options, they become selected as if I was editing them. If I unprotect the worksheet and enter developer mode, they are all selectable and editable.

I have 20 of these workbooks, this seems to happen to one a week. I generally use a saved copy that works to replace the one having problems, but this is a temporary solution and results in data loss. Any ideas on what might be happening, and what I can do to fix it? I'm using Excel 2013, we upgraded to Office 365 back in June, just before I was brought on to this project.

Thanks in advance for any help, this is frustrating!

Are they on worksheets on in userforms?

You're better off not using ActiveX controls on worksheets at all. They're incredibly unstable have a look here https://www.google.co.uk/webhp?sourc...eet%20controls and by using them, you're asking for trouble.

Forms controls are much more reliable - they're in the same dropdown as the ActiveX ones, but are designed for use on worksheets - so you don't run into any stability issues, you can do most of the same things with them too and you can use them without using code.

They are on worksheets...about 20 different ones, they transfer data to a secondary worksheet for data collection. Each has different rules...different calculations, different columns, some have a series of charts involved, so remaking them all isn't really an option.

I feel like there is something being selected, some option being enabled that I am missing here, for all the controls to be basically shut down at once.

Thanks,
Jim

Then I wish you the best of luck as I fear that you may not find an answer - ActiveX controls on worksheets are notoriously unstable