Excel crashes on attempting to open VBA editor

%3CLINGO-SUB%20id%3D%22lingo-sub-131524%22%20slang%3D%22en-US%22%3EExcel%20crashes%20on%20attempting%20to%20open%20VBA%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131524%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20guys%2C%3C%2FP%3E%0A%3CP%3Eone%20of%20my%20workbooks%20crashes%20when%20I%20try%20to%20open%20VBA%20editor.%20Do%26nbsp%3B%20you%20know%20how%20to%20fix%20the%20problem%20or%20extract%20the%20macros%20from%20such%20workbook%3F%3C%2FP%3E%0A%3CP%3EThanks%20a%20lot%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-131524%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20%26amp%3B%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-357861%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20crashes%20on%20attempting%20to%20open%20VBA%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357861%22%20slang%3D%22en-US%22%3EAmazing...It%20works%2C%20thanks%20a%20lot.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314104%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20crashes%20on%20attempting%20to%20open%20VBA%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314104%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20solution%20said%20works.%3C%2FP%3E%3CP%3EThanks%20for%20the%20solution%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-291061%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20crashes%20on%20attempting%20to%20open%20VBA%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-291061%22%20slang%3D%22en-US%22%3E%3CP%3Emany%20users%20repair%2C%20uninstall%2C%20reinstall%20office%20and%20some%20users%20even%20reinstall%20windows%20and%20the%20solution%20is%20quite%20simple%20right%20in%20front%20of%20your%20nose.%20all%20these%20problems%20happened%20due%20to%20the%20new%20Beta%20feature%20for%20Region%20setting%20using%20unicode%20UTF-8%20for%20worldwide.%20correction%20of%20this%26nbsp%3Bstupid%26nbsp%3Berror%20which%20cost%20me%20a%20lot%26nbsp%3Bof%20time%20and%20effort%20is%20very%20simple.%3C%2FP%3E%3CP%3E%3CSTRONG%3Econtrol%20panel%20%26gt%3B%26gt%3B%20Region%20%26gt%3B%26gt%3B%20Administrative%26nbsp%3Btab%20%26gt%3B%26gt%3B%20change%20system%20locale%20%26gt%3B%26gt%3B%20untick%20the%20box%20%22%20Beta%3A%20Use%20Unicode%20UTF-8%20for%20%3C%2FSTRONG%3Eworld%20wide%3CSTRONG%3E%26nbsp%3Blanguage%20support%22%3C%2FSTRONG%3E%20.%20that's%26nbsp%3Bit%20problem%20solved%20.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F60655i7FC1BA8A3D6E3904%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.JPG%22%20title%3D%22Capture.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-131674%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20crashes%20on%20attempting%20to%20open%20VBA%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131674%22%20slang%3D%22en-US%22%3E%3CP%3EAfter%20trying%20everything%20I%20have%20killed%20outlook.exe%20process%20and%20it%20suddenly%20worked%20LOL%20%3CLI-EMOJI%20id%3D%22lia_grinning-face-with-smiling-eyes%22%20title%3D%22%3Agrinning_face_with_smiling_eyes%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-131596%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20crashes%20on%20attempting%20to%20open%20VBA%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131596%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%20class%3D%22%22%3EAnother%20try%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%20class%3D%22%22%3EOpen%20a%20blank%20workbook%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%20class%3D%22%22%3EPress%20Shift%2BF12%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%20class%3D%22%22%3EFind%20that%20workbook%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%20class%3D%22%22%3EClick%20it%20one%20click%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%20class%3D%22%22%3EClick%20the%20down%20arrow%20next%20to%20%3CSTRONG%3EOpen%3C%2FSTRONG%3E%20button%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%20class%3D%22%22%3ETry%20each%20one%20of%20these%20options%3A%20%3CSTRONG%3EOpen%20and%20Repair%3C%2FSTRONG%3E%2C%20%3CSTRONG%3EOpen%20in%20Protected%20View%3C%2FSTRONG%3E%2C%20and%20%3CSTRONG%3EOpen%20Read-Only%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%20class%3D%22%22%3E%3CIMG%20class%3D%22x-hidden-focus%22%20src%3D%22https%3A%2F%2Fsupport.content.office.net%2Fen-us%2Fmedia%2F308a7773-9c32-4a26-a632-7ef5b3df2b07.png%22%20alt%3D%22Open%20and%20repair%20command%22%20title%3D%22Open%20and%20repair%20command%22%20border%3D%220%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%20class%3D%22%22%3EUseful%20Link%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%20class%3D%22%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FRepair-a-corrupted-workbook-153A45F4-6CAB-44B1-93CA-801DDCD4EA53%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ERepair%20a%20corrupted%20workbook%3C%2FA%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-131572%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20crashes%20on%20attempting%20to%20open%20VBA%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131572%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20thank%20you%20for%20reply!%20I%20think%20it%20must%20be%20something%20with%20macros%20but%20I%20have%20tried%20to%20disable%20macros%20and%20clear%20trusted%20documents%20but%20my%20spreadsheet%20crashes%20or%20freezes%20on%20saving.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-131569%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20crashes%20on%20attempting%20to%20open%20VBA%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131569%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%3EBad%20macros%20may%20have%20caused%20this!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EYou%20have%20to%20numb%20these%20macros%20to%20be%20able%20to%20open%20the%20VBA%20editor.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%20this%3A%3C%2FP%3E%0A%3CP%3EGo%20to%20Developer%20Tab%20%26gt%3B%26gt%3B%20Macro%20Security%20%26gt%3B%26gt%3B%20Macro%20Settings%3C%2FP%3E%0A%3CP%3EAnd%20make%20sure%20that%20the%20macro%20setting%20is%20%3CSTRONG%3E(Disable%20all%20macros%20with%20notification)%3C%2FSTRONG%3E.%3C%2FP%3E%0A%3CP%3EThen%20go%20to%20%3CSTRONG%3ETrusted%20Documents%20%3C%2FSTRONG%3Eand%20press%20%3CSTRONG%3EClear%3C%2FSTRONG%3E%20button.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfter%20that%2C%20save%20and%20close%20the%20workbook%2C%20then%20open%20it%20again.%3C%2FP%3E%0A%3CP%3ETry%20to%20open%20the%20VBA%20editor%2C%20and%20look%20what%20the%20problem%20is.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-532230%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20crashes%20on%20attempting%20to%20open%20VBA%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-532230%22%20slang%3D%22en-US%22%3EThanks%20for%20the%20solution.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-658375%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20crashes%20on%20attempting%20to%20open%20VBA%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-658375%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F246091%22%20target%3D%22_blank%22%3E%40DATA00%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20still%20get%20the%20above%20described%20error%2C%20but%20my%20Region%20Settings%20does%20not%20have%20the%20offending%20Beta%20box.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116578i5303D0894B2A6D7F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22screenshot1.JPG%22%20title%3D%22screenshot1.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-834587%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20crashes%20on%20attempting%20to%20open%20VBA%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834587%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F246091%22%20target%3D%22_blank%22%3E%40DATA00%3C%2FA%3E%26nbsp%3BExcellent%20answer!%20It%20worked%2C%20thanks!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-839347%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20crashes%20on%20attempting%20to%20open%20VBA%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-839347%22%20slang%3D%22en-US%22%3EIt%20did%20solved%20the%20problem%20for%20me%2C%20thanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-870109%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20crashes%20on%20attempting%20to%20open%20VBA%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-870109%22%20slang%3D%22en-US%22%3EThanks%2C%20it%20works.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1254630%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20crashes%20on%20attempting%20to%20open%20VBA%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1254630%22%20slang%3D%22en-US%22%3E%3CP%3Ehallelujah%2C%20you%20saved%20my%20day%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F246091%22%20target%3D%22_blank%22%3E%40DATA00%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hey guys,

one of my workbooks crashes when I try to open VBA editor. Do  you know how to fix the problem or extract the macros from such workbook?

Thanks a lot

13 Replies
Highlighted

Hi,

 

Bad macros may have caused this!

You have to numb these macros to be able to open the VBA editor.

 

Try this:

Go to Developer Tab >> Macro Security >> Macro Settings

And make sure that the macro setting is (Disable all macros with notification).

Then go to Trusted Documents and press Clear button.

 

After that, save and close the workbook, then open it again.

Try to open the VBA editor, and look what the problem is.

 

Highlighted

Hi thank you for reply! I think it must be something with macros but I have tried to disable macros and clear trusted documents but my spreadsheet crashes or freezes on saving.

Highlighted

Another try

  • Open a blank workbook
  • Press Shift+F12
  • Find that workbook
  • Click it one click
  • Click the down arrow next to Open button
  • Try each one of these options: Open and Repair, Open in Protected View, and Open Read-Only

 

Open and repair command

 

 

Useful Link:

Repair a corrupted workbook

After trying everything I have killed outlook.exe process and it suddenly worked LOL :D

Highlighted

many users repair, uninstall, reinstall office and some users even reinstall windows and the solution is quite simple right in front of your nose. all these problems happened due to the new Beta feature for Region setting using unicode UTF-8 for worldwide. correction of this stupid error which cost me a lot of time and effort is very simple.

control panel >> Region >> Administrative tab >> change system locale >> untick the box " Beta: Use Unicode UTF-8 for world wide language support" . that's it problem solved .

Capture.JPG

 

 

 

Highlighted

The solution said works.

Thanks for the solution

Highlighted
Amazing...It works, thanks a lot.
Highlighted
Thanks for the solution.
Highlighted

@DATA00 

I still get the above described error, but my Region Settings does not have the offending Beta box.

 

screenshot1.JPG

Highlighted

@DATA00 Excellent answer! It worked, thanks! 

Highlighted
It did solved the problem for me, thanks
Highlighted
Thanks, it works.
Highlighted

hallelujah, you saved my day@DATA00