Forum Discussion
Multiple *.xlsm files no longer recognize attached VBA modules and files are uneditable/unsaveable.
After the crash I reopen the file and the modules exist but I can neither see into them nor export them, and I cannot save the file nor repair it (rather, Excel repair always fails).
I guess the defender may result it.
If you want to avoid it occurs again,I guess you need close the defender anti-virus when.you open .xlsm file next time.
As to the VBA module,if you have backup, just restore it.
If you want to extract the Vba codes from the file you can not see,you can upload your .xlsm file,let us see whether it is possible to export those VBA modules as text.
peiyezhu I am already exporting the modules as *.bas and have already doubly backed up some as text. The problem is that the *.xlsm file is now useless (un-repairable). I am losing one to three files DAILY and have to TRY to re-enter all of the data I lost since the last save. Some of the larger files I am backing up to *.xlsx then importing the *.bas and resaving as *.xlsm (but even that does not work all of the time as the "new" *.xlsm opens as un-editable/un-repairable.