System Error &H8000FFF (-247418113). Catastrophic failure

Question

I have now twice had this error, where I email a spreadsheet with macros to another person. It is working when I send it using share via email. When they get it there is a problem. When I go and open the original, I also get the problem. System Error &H8000FFF (-247418113). Catastrophic failure and when I go to look at the code it is all gone. Does anyone know the cause and solution?

One strange this that happened, I would get an error when clicking on the Data tab, something to do with Funcres. When I when I looked online, it said this was an add-in. Since I wasn't using it, I disabled it. Not sure if that is related.

Answer 1

So I figured it out. The issue was I had left a black module in the VBA editor. I had recosted a macro to get a code for a color and then deleted the macro but did not delete the module2.

I did this on two different spreadsheets for two different people. They were working when I sent them but crashed for them. When they sent them back they crashed for me.

The one thing they had in common was this empty module2. I entered each with macros disabled, deleted the module2's and enable macros and both are now working fine and have been for weeks.