Can't find Project or Library but VBA editor is fried. (tragic! Please help)

[hellfire45]

Hi Guys and Gals,

I have an automated workbook I spent a lot of time creating and I'm getting this annoying "Can't find project or library" error when I open the workbook. I have seen this before.

So I head straight for the VBA reference window so I can deal with it, and the VBA Editor is like dead. I cannot see the code. I cannot bring up the references box from the tools menu. And when I try to save the modules so maybe I can rebuild it, it says "module not found".

What in the heck is going on? How can I save this workbook?

 

[Alex Blakenburg]

I don't know much about this but see if any of the ideas in this help at all. Mind you the only easy (non-tech) suggestion is probably the mismatch in Language settings one.
How do I recover this VBA Project? Excel Error message: "Removed Part: /xl/vbaProject.bin part."

Just in case it give you any other ideas, I got to the above by unzipping a VBA workbook and saw a vbaProject.bin file in the xl folder.