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!

 

[jkpieterse]

What happens if you try to attach a macro to a button? Are the macros inside the BOM workbook or in some other Excel workbook?

 

[SPS41]

What happens if you try to attach a macro to a button? Are the macros inside the BOM workbook or in some other Excel workbook?

Hi, thanks for replying so quick! When I try to assign a macro and click ok, it’s closes out the dialog box with no errors and all the macros and data are all in the same workbook. The source to the power query editor is the only external piece of data.

 

[SPS41]

Hi, thanks for replying so quick! When I try to assign a macro and click ok, it’s closes out the dialog box with no errors and all the macros and data are all in the same workbook. The source to the power query editor is the only external piece of data.

Quick update, as I was checking my excel document, now all the buttons don’t work. It’s like they don’t like macros or something. I’ve never seen this happen before

 

[Joe4]

My BOM workbook worked fine until I moved my Master list excel sheet to one drive

Where exactly are you trying to run them from?
They will not work when running Excel from the Web, only when running from the Desktop App of Excel.

 

[SPS41]

Where exactly are you trying to run them from?
They will not work when running Excel from the Web, only when running from the Desktop App of Excel.

All the excel files are stored on the server. All on the desktop app. I’m not using excel on the web.

 

[jkpieterse]

What happens if you try to assign a macro to a shape, like a rectangle?

 

[SPS41]

What happens if you try to assign a macro to a shape, like a rectangle?

I tried assigning to a forms control button (which is a shape right?) I also tried to a regular shape. I right click the shape/button, assign macro, select desired macro, under the drop down that says macros in: I select the name of my current workbook. And click ok. The dialog box closes as if it’s all good. But when I click the shape/button nothing happens.

 

[jkpieterse]

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

 

[SPS41]

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

Yeah I’m currently running the macro from the Macros button in the Developer tab.