Excel 2007 Issue: Pre-programmed buttons suddenly do not work
Today, in blue, the form that the company I'm working with to use suddenly came across these buttons. Oddly enough, it only affects what I'm pretty sure is the ActiveX command buttons and doesn't cause problems with other forms or dropdowns.
Problem. The buttons do not respond. When you click, they don't access the code or test them through the shapes menu, and selecting "view code" makes them open the developer menu, but not the code associated with them. The really big problem is that for some reason they all seem to start crashing at the same time. The version on the server no longer works (master copy), the copy the user is using (notorious for hacking things) and the version you are using (which is on my local machine).
Is there a way to get them to re-link them to the correct code without deleting them completely republishing them, or perhaps someone who had the same problem and figured out a fix?
I am very grateful for any suggestions or help - please note: I am 99.9% sure the problem is not code based.
source to share
The issue is caused by a recent update of Office. Here is the fix posted at http://excelmatters.com/2014/12/10/office-update-breaks-activex-controls/
To fix this, do the following:
- Close all Office applications.
- Do a search in Windows Explorer - make sure to include hidden and system files and folders - for * .exd files (note: this is not * .exe!) And delete whatever you find. Make sure you get: C: \ Users \ username \ AppData \ Local \ Temp \ Excel8.0 \ MSForms.exd C: \ users \ username \ AppData \ Local \ Temp \ VBE \ MSForms.exd
- Restart your computer (this is not always necessary, but probably better secure than sorry)
- Restart the Office applications and test the controls again.
source to share