Can't open module

Hello,

I have a set of macros in several workbooks that I have been running everyday for about a year now without issues (except for ones I have been been able to easily fix myself).
Starting this morning excel started crashing when running one of them.
I narrowed it down to which workbook had the macro that was causing the crash, but...

When I open the developer tab, and double click on any of the modules in the workbook, nothing happens (grey screen to right where code usually pops up)

Snip of VBA menu attached... neither module will open.

Any/All help appreciated!

My apologies,

I was hesitant to include the actual workbook since there is so much potentially sensitive data in it, and the macro specifically calls out the workbook name, so I couldn't change title either without alot of work.

That being said, I saved the document (with the same name) in a separate location and replaced all data with random values within a reasonable range.

After saving in the different location, I was able to open up the modules in question, so uploading now wouldn't show the problem of not being able to open the modules.

The original location is on a company server, so perhaps I need to get with my local IT on settings of the folder...

Matrixman,

When I try to 'save as' on the desktop I get the following message:
Errors were detected while saving 'FILE PATH & NAME'. Microsoft Excel May be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel.

when i click continue, the following message:
Excel encountered errors during save. However Excel was able to minimally save your file to 'FILE PATH & NAME'

when that dialog box is closed, I get the message from attached snip.


I assume that means my file has been corrupted?

Thanks Matrixman, I'll manually move everything to a fresh file (sigh) and see if that fixes it.
I'll let you know when I'm done.

Well I finished redoing the sheet manually, and replaced the old corrupted file, and everything is working smoothly again.

Thanks Matrixman!