Forum Discussion
Excel crashes on attempting to open VBA editor
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
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.
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.
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
Useful Link:
After trying everything I have killed outlook.exe process and it suddenly worked LOL :D
