I'm running Excel 2016 in Office 365 Pro Plus and am having a problem I haven't been able to find anywhere else. Specifically, virtually every time I open Tools > References in the VB Editor, the references that are selected have changed. There are 4 specific references where this is a problem:
- Microsoft Visual Basic for Applications Extensibility 5.3
- Microsoft Scripting Runtime
- Microsoft Forms 2.0 Object Library
- IlydaUK Ribbon Commander v1.1 (third-party add-in)
One or more of the above 4 will be unchecked anytime I check after re-checking them.
I read one apparently related post that suggested making sure all were checked in the personal workbook. I checked the ones that weren't and that lasted only about a hour, including in the personal workbook.
I've also seen some posts that make reference to late vs. early binding but could never find any specifics about how to set that up.
Any additional suggestions will be deeply appreciated.