I missed that bit. I hate those buttons and quickly convert them
to control toolbox ones whenever they appear in stuff I'm working on. :-)
I've just had a bit of a play with a form button, and I don't think it actually
has a name as such. (Or at least not a visible one.)
What happens is that the button can be associated with a subroutine and you have
the ability both to name this subroutine and to record actions for it. Excel
provides a default name for this subroutine.
I just created a button and it brought up the assign macro popup. It wanted to
assign to "Button1_Click". I changed the name of the macro to "Fred" and then
hit record and recorded some stuff. Once I'd finished the recording, my Module1
VBA module had only a "Fred" subroutine in it.
Similarly, you can change the name of the subroutine attached to an existing
button. Best way is to create the new subroutine first, then go to the "assign
macro" for the button and you'll see the new subroutine in the list. Select it
and the old identity seems pretty much gone.