Missing Macro in excel

Occasional Visitor

I have recoded macros in an excel file and they run fine.  Intermittently those macros will not be in the macro list and i have to use a backup copy to recover.  I am saving to one drive.  If I go to the VBA editor the modules are still there and I can run them from there.  

 

Why do the macros go missing from the macro list?  This also happens if I save them to a personal file.

0 Replies