Unexplained "Automation error Exception occurred" from Excel

Question

I'm getting "Automation error Exception occurred" (+ crash) from Excel 2016 for all macros for all workbooks. Started happening some time in the last week (same code worked fine last week)

I created a test case, empty workbook with a single module.

---

Option Explicit

Option Base 1

Public Sub DoIt()

MsgBox "Done" 

End Sub

---

If I run it with F5 from inside the VBA editor, it works fine.

If I run it from Developer > Macros > DoIt, error + crash.

I tried doing a "repair" of my office installation, no change.

Thoughts?

Answer 1

Here's the solution (since my problem hadn't gone away).

• Open the VBA editor (Alt + F11)
• Tools > References
• check-mark "AccessibilityCplAdmin 1.0 Type Library"
• SAVE
• (close and reopen Excel)

I learned this in Stack Overflow and it worked like a charm.

Answer 2

I had this happening and figured out it was ONLY if the file was stored on my OneDrive folder. If I moved the workbook file back to C drive or anywhere else, such as a normal network drive, the same macro worked.