The Office update (Tuesday 9th Dec 2014) has broken ActiveX controls on worksheets. The symptoms include:
- Being unable to use or change properties of any active controls on worksheets
- Error messages saying “Can’t insert object”
- Error 438 when trying to refer to an activex control as a member of a worksheet in code
To fix it, do this:
Close all Office applications.
Do a search in Windows Explorer – make sure to include hidden and system files and folders – for *.exd files (note: that’s not *.exe !!) and delete any you find.
Make sure you get these:
Reboot the computer (this is not always necessary, but probably better safe than sorry)
Restart your Office apps and test the controls again.