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?