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 could solve it by saving it under another name (place)

Answer 3

This did help me. Thanks!

Answer 4

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.

This works!! Thank you so much!

Answer 5

This seems to be working for me.

Thanks