Macro enabled workbook crashes but opens with macros disabled. Message written to error log;


Faulting application name: EXCEL.EXE, version: 14.0.6117.5003, time stamp: 0x4f622ef8
Faulting module name: VBE7.DLL, version: 7.0.16.25, time stamp: 0x4e49ae34
The version of Excel may vary as may the version of VBE.DLL


The following resources describe methods to recover. 

Excel crashes when enabling macros

Enabling Macros Causes Excel To Freeze & Crash!

Excel crashes in VBE7.DLL running or enabling macro


In my case, it was resolved by;

  1. Disable macros via, Options > Trust Center > Trust Center Settings > Macro Settings > Disable all Macros
  2. Open problematic spreadsheet. Ignore message to enable Macros
  3. Add a new Worksheet to the spreadsheet, save and then close spreadsheet.
  4. Enable macros via, Options > Trust Center > Trust Center Settings > Macro Settings > Enable all Macros
  5. Open problematic spreadsheet
  6. Execute macro to test