I was able to assign the macro when it was in the same workbook as my worksheet but as it turns out the macro will only work if it's outside of the workbook. I cannot figure out how the macro is called from the button's sub now that it's in the PERSONAL.XLSB!Macro2



Before: I could just simply use
I tried

but that doesn't work.

The original problem as I've read is that updating between workbooks would require that the macro be outside the workbooks. So I've moved it and it does work from the run macros menu. But now it won't work when assigned to a button because, I believe, I am not referencing it properly.

If the button is a shape you made, Right-click on the shape and choose Assign macro

Ok, when I tried it with a form button I made, it wouldn't work.
But when I made a active x button it immediately asked which macro to assign to it.

It now works!

I didn't get the assign macro context in the menu when I right-clicked the original button. But I did notice that under the View menu and submenu macros that the use relative references was an available option. How does thatwork?