'System Error &H8000FFF (-247418113). Catastrophic failure

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.



Solution 1:[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.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Gus