File crashes Excel!! Battlefield 2 Forgotten Hope 2 Maps. Save my workbook! The best tool for salvaging problematic workbooks. Excel VBA Masterclass (English) Excel VBA for Financials (Dutch).

Office Update breaks Active. X controls. UPDATE: 1. March 2. 01. 5: Microsoft have now released fixes for this! For Excel 2. 00. 7 click here. Carpet And Rug Institute Installation Guidelines For Modified. For Excel 2. 01. 0 click here.

For Office 2. 01. The symptoms include (but are probably not limited to): Being unable to use or change properties of any active controls on worksheets. Error messages saying “Can’t insert object”Error 4.

• A VBA Function To Get A Value From A Closed File. Category: VBA Functions
• Adding Code to an Excel Workbook. Tips for copying VBA code to a workbook, and checking the code, to ensure that it runs without errors.

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 *. Make sure you get these: C: \users\username\App. Data\Local\Temp\Excel. MSForms. exd. C: \users\username\App. Data\Local\Temp\VBE\MSForms. Reboot the computer (this is not always necessary, but probably better safe than sorry)Restart your Office apps and test the controls again.

Please note that the . Hopefully that will resolve the problem for you.

That should open explorer to the Temp folder and you then need to look in the Excel. VBE folders for the . Word. 8. 0)Update: 1. Dec: It seems that for a few cases so far, this solution doesn’t resolve the issue. I will post back if and when I discover a solution for those cases too, though simply uninstalling the update mentioned at the beginning of this post may be a solution until a fix is released. Trust me, Microsoft is aware that this is an issue – see their blog post here. Update: 1. 2 Dec 2.

I have seen mentions that if none of the above fixes the issue in Office 2.