Excel 2010 command button no longer fires _Click () event
I have several command buttons for a worksheet that fire their click event (_Click) when clicked. They worked for several years and then they suddenly stopped working. And what's more, VBA errors with "Variable not defined" when the workbook is open, but when I go into design mode, I see the name of the control, and when I double click on it, it displays the VBA () VBA code for the sheet.
I checked in archived versions and now they react the same way. I thought it might have been some setting changed in my Excel options, but this happens in both home and work versions of Excel (2010 at home and 2007 at work).
What's happening?
source to share
After a recent (December 10, 2014) automatic update of Microsoft Office,
cached control type libraries (extension files, * .exd) may be out of sync. To resolve this issue, you must remove the cached versions of the control type libraries (extension files) on the client computer.
Decision:
All * .exd files must be removed; they will be automatically generated automatically the next time they need Office.
To do this, first close all Office applications and then either:
Put this in a batch file (text file with .bat extension) and execute it.
del %temp%\vbe\*.exd
del %temp%\excel8.0\*.exd
del %appdata%\microsoft\forms\*.exd
del %appdata%\microsoft\local\*.exd
del %temp%\word8.0\*.exd
del %temp%\PPT11.0\*.exd
Or, alternatively, find your hard drive for the named files *.exd
and delete them all, although if you have unlinked files with a .exd name extension, be careful not to accidentally delete them!
Source: TechNet.com
source to share