Microsoft Excel ActiveX Controls Disabled

11/12/2014 § 2 Comments

Due to the MS Update and that a good fix is to simply delete the file MSForms.exd from any Temp subfolder in the user’s profile. For instance:
C:\Users\[user.name]\AppData\Local\Temp\Excel8.0\MSForms.exd
C:\Users\[user.name]\AppData\Local\Temp\VBE\MSForms.exd
C:\Users\[user.name]\AppData\Local\Temp\Word8.0\MSForms.exd
Of course the application (Excel, Word…) must be closed in order to delete this file.

*****
Source:
http://stackoverflow.com/questions/27411399/microsoft-excel-activex-controls-disabled

===========
Please follow link from the Yi comment

Advertisements

Tagged: ,

§ 2 Responses to Microsoft Excel ActiveX Controls Disabled

  • Yi says:

    Actually renaming the *.exd files in VBA is possible even when Excel is running, and it fixes the issue as well. I wrote a VBA snippet that tries to rename the *.exd file in the Workbook_Open event. I’ve posted the code on my website. Developers can insert the snippet into their spreadsheets they’re distributing, and their spreadsheets should continue to work. It’s not a perfect fix, but it gets the job done for now.

    http://www.excelclout.com/microsoft-update-breaks-excel-activex-controls-fix/

    Yi

    • amagama001 says:

      Thank you Yi, I didn’t try yet but I think that this is the easiest way to remove this issue because it will be inside excel.

      Tested, it works perfectly!!!
      Thank you Yi!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

What’s this?

You are currently reading Microsoft Excel ActiveX Controls Disabled at RheXenoR.

meta

%d bloggers like this: