vba - How to make Microsoft Web Browser object work in Excel 2016

Question

When I try to insert it, I constantly get the "Cannot insert object" error. It seems to be a known issue with former Excel versions, but I couldn't find any support for 2016.

Has anyone been able to make this work?

Here are screenshots:

Answer 1

This appears to be intentional behaviour from Excel 2013 onwards. From this article:

This issue occurs because some scriptable controls are made obsolete in Office 2013 for security reasons. This is by design, and these errors are expected.

There is a workaround posted in that article which involves editing the registry to make these controls work again.

(The KnowledgeBase article was originally linked from this Microsoft community thread from 2014)