.
.
It sounds like you might not be assigning the macro properly ?

Go to the DEVELOPER TAB / INSERT ... click it.

In the upper left hand corner is the graphic for a Command Button ... click it.

Place your cursor on the sheet approximately where you want the button positioned (you can move it late if necessary).

Left click the mouse. The button is on the sheet and another window opens with macro names showing.

Left click the macro name you want .. Click OK.

Done.


When you return to the Macro Assign window, the macro name appearing in the Macro Name Field might not necessarily be the macro you expect. If your macro was assigned to the button once,
it will stay that way until you change it.

If the assigned macro is truly changing without your help, you either have a corrupted workbook or a bad install of Excel that needs repair ?