Cannot assign macro to button

[SPS41]

Hi all,
I have an excel workbook called Bill of Materials (BOM), which contains a lot of macros and I have always had buttons call certain macros. My BOM excel sheet basically uses power query to organize data sourced from a workbook called Masterlist and throws it on a new sheet (on the BOM workbook). Then a v lookup copies relevant data from that new sheet on my active worksheet (again on the BOM wb).
But my issue starts here. My BOM workbook worked fine until I moved my Master list excel sheet to one drive, it’s like I broke the whole BOM workbook. My macro works but the button will not execute the macro no matter how many times I assign the macro to it or how many new buttons I create and try to assign the same macro.
I know there are some issues with excel and one drive but I don’t know if that’s what broke the sheet?
All the macros work fine, I just cannot add it to a button.
Let me know if you need more info. I can attach prices of relevant code but I don’t know if that will help. I can if need be.
Thanks in advance for all your help!

 

[SPS41]

And you can manually run the code from the VBA Editor or from alt+F8? If so, maybe a reboot is needed?

Reboot worked. I have been tearing my hair out for the past 4 days. I going to go meditate now lmao!
Thanks for all the help guys! You’ve really helped me out. Appreciate the time and effort.

Thanks again!