Multiple *.xlsm files no longer recognize attached VBA modules and files are uneditable/unsaveable.

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.