I have had this same problem a few months ago. My code even crashed on simple statements like Sheet1.Range("A1").Value = 12 (this due to the compilor not making visible the options)
Here is what I did:
-remove all modules from your workbook, and save them somewhere on your computer (right-click on a module, then select export)
-export your sheets code as well (if you have any)
-save the workbook, re-open it and goto VBE.
-here import your modules and sheet modules (File>Import File)
-if you have everything back to normal, save the workbook again.
-again re-open it, and it should work fine now.
Now if this doesn't work, try the following. Open your workbook, and goto File>Save As. Here choose the Type to Excel 97-2000 workbook.
Hope this will help