When I attempt to run a macro from the tools menu in the VBA editor I get varying errors (tools -> macros). Initially I could open the macros menu but when I attempt to run a particular macro from the list, excel crashes and closes without any error report. I tried opening the file again and all the macros seem to run in the spreadsheet but I get the same error when attempting to run the macros with the vba editor. I thought maybe the VBA code file is corrupt so I have tried stripping the VBA code out of the file, saving it as a non-macro enabled file, and then reassemble a new macro enabled file. Now I get an "out of memory error" before the macros menu even opens in the editor.