I have an xlsm file that I was working on it and somehow while I was in the VBE it crashed, upon re-opening it throws this error.
I have a workbook_open event so it cannot run it of course. When I go to VBE the name of the project is gone as if the name of the project is a whitespace as you can see below
When I try to open Tools>references nothing shows up. When I click stop execution button in the VBE Excel crashes. I also tried to used a repaired and recovered xlsb file by Excel says the damage was too extensive that it could not recover most of the data. I don't care about the data, but I just need to recover my macros. Anyone has faced this kind of challenge? BTW the project is password protected, I can unlock it without any problem