Macros in Macro-enabled workbooks randomly disappear

[Hondapotamus]

So I've searched using a variety of queries but all of them point to losing or not having their personal macros workbook. THAT IS NOT MY PROBLEM (not shouting just emphasizing - don't respond with anything about the personal macro workbook please).

We have workbooks (xlsm) that have approximately 6000 lines of vba code in them. Each of the 47 workbooks have the same code in them. Excel will randomly - and I mean randomly with no common denominator in circumstances, completely remove ALL of the macros from one of the workbooks (not always the same workbook - that too is random). No one saves them as an xlsx - so that is NOT the problem.

I've reviewed my code multiple times to ferret out what may cause the problem, but to no avail.

Does this happen to anyone else? I vaguely recall reading something where it was mentioned that the macros are still there just not visible in the VBA editor and how to get them back. I can't relocate that and I wondering if anyone has some insight into what may be happening to my workbook.

Thanks
"Frustrated with Microsquash"

 

[GWteB]

Don't know if it's a similar issue but you might take a look over here ...

Rescuing My Work From VBAProject.bin

Hello, I have been working for the last few days on a macro only for me to come into work this morning and be presented with the message 'Excel has found unreadable content in this file, do you want to recover it' on opening. If I click yes then all of the VBA work I have done has been...

www.mrexcel.com