@ChasPx
As far as I know (but that doesn't mean much), the only file type .xlsx cannot save VBA codes. If you try to save VBA codes with this file type, you get a warning every time. These warnings have apparently been consistently ignored.
Here is some information about self-help
1. Repair a damaged workbook
Click on File> Open.
Click the location and folder that contains the damaged workbook.
In the Open dialog box, select the damaged workbook.
Click the arrow next to the Open button, and then click Open and Repair
2. Repairing a corrupted workbook
https://support.microsoft.com/en-us/office/repairing-a-corrupted-workbook-7abfc44d-e9bf-4896-8899-bd...
If the file does not open at all, then open the file with Openoffice first, the file will be opened safely. But it is very likely that if the macros are gone, they cannot be regenerated.
3. There are also external tools with which one could try it out.
Stellar Excel Repair Tool
https://recoverit.wondershare.com/microsoft-excel-repair.html?_ga=2.229166814.336969362.1612797391-6...
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
