Forum Discussion

Samuel Vrbovský's avatar
Samuel Vrbovský
Copper Contributor
Nov 27, 2017

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
Macros & VBA
Need Help
Samuel Vrbovský's avatar
Samuel Vrbovský
Copper Contributor
Nov 27, 2017

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.

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Nov 27, 2017

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

  • Samuel Vrbovský's avatar
    Samuel Vrbovský
    Copper Contributor
    Nov 27, 2017

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

Resources