If you run into Error 438 recently with JMC Excel please use this fix
below found by one of Excel user (Alpesh patel). Thanks to Alpesh for
being kind enough to find the solution himself and send me the detail.
Below are the detail of his guide. Thanks again Alpesh for helping.
http://stackoverflow.com/questions/27411399/microsoft-excel-activex-controls-disabled
http://support.microsoft.com/kb/3025036/EN-US
Hi Alpesh,Below are the reference sites Alpesh quoted:
I thought I would let you know that I found the answer to Run-time error 438 appearing whenever I try to use JMC.
I discovered this is from an automatic Microsoft update that downloaded in Dec 2014 and affecting JMC as well as active X controls in Excel.
To repair, I simply had to delete all *.exd files:
del %temp%\vbe\*.exd
del %temp%\excel8.0\*.exd
del %appdata%\microsoft\forms\*.exd
del %appdata%\microsoft\local\*.exd
del %appdata%\Roaming\microsoft\forms\*.exd
del %temp%\word8.0\*.exd
del %temp%\PPT11.0\*.exd
Everything works again! Hope this helps you should you receive any other emails regarding this error.
Kind Regards,
Alpesh
http://stackoverflow.com/questions/27411399/microsoft-excel-activex-controls-disabled
http://support.microsoft.com/kb/3025036/EN-US
