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.