Excel Macros Disappear

Hi all,

I have installed a set of Excel Macros into my excel. They were working original (with the tab showing up in the ribbon) but have since disappeared. I followed many troubleshooting steps including unblocking the source file within it's add-in folder location and adding the add-in folder location to trusted locations within the trustcenter. However, I still cannot get the macro to re-appear and work in my excel. Any suggestions on how this could be fixed? Appreciate the help

This is about the fourth time in 2 years where I am working on a spreadsheet containing macros, saving the file under .xlsm as has been since creation, to later find that the macros are completely gone. These files are updated daily, accessed directly from my laptop from files saved on OneDrive.

Through research, the recommendations of:
1. locating the file via C:\Users\******\AppData\Roaming\Microsoft\Excel\XLSTARTSent does not work as the XLSTARTSent is nonexistent
2. going to Excel Options, Add-Ins, selecting Disabled items does not provide a selection for Personal Workbook

The Modules by name are still listed, however, the macros are not provided.

I'm at a loss and do not know what to do. These are crucial files that I use daily to perform my daily duties.