Macros dissapearing over and over

[STIRRELL]

Hi- I have a xlsm workbook that two nights in a row the macros disappear. They even disappeared from the files that I archived as a backup ( also xlsm files). I checked that macro is enabled and I checked that there were no disabled add-ins.
I have never had this happen before. Any suggestions? I am using Office 365.


Macro Settings- Enable VBA macros( not recommended; potentially dangerous code can run)
enable excel 4.0 macros VBA project object model is checked
Developer Macro settings Trust access to the VBA project object model is checked.

Please help
Sharon

 

[ranman256]

Odd, since ,xlsx WILL erase all macros.
but .xlsm and .xls will not erase them. Never seen .xlsm erase them.

have you tried saving the macros in the PERSONAL wb so they always exist no matter the xl workbook?