Brain fart. Can't find button properties to change button name.

[9tanstaafl9]

Sorry for the idiotic question but I've searched for an hour now and can't find it. I have an old excel worksheet with a button on it that needs to be renamed. Last time I renamed a button I thought I had just right clicked on it and properties was an option and I could type over the button name. Now I'm using Excel 2013 (possibly I was using an earlier version before?) on a new computer, and I do not see this option. It looks like Excel thinks my button is a picture. It definitely is NOT.

Any help appreciated.

 

[9tanstaafl9]

Here is the dropbox link. https://dl.dropboxusercontent.com/u/38305730/to send buttons.xlsm

I had to remove all the confidential info, so all that's left is the buttons.

Don't spend too much time on this as I do have a viable workaround. Just look at it if you're curious.

Thanks again for all your help!

 

[shg]

I've lost the purpose of this drill ...

Controls from the Forms toolbars don't have Properties a la ActiveX controls, right?

 

[SpillerBD]

Oh WOW. Each button is comprised of 12 (if I got it right) elements. So if you could click on the right element in the group it would behave as intended.
There may some issue with which element is driving everything and as long as versioning updates didn't foul (fowl, cluck up) up the front most element.....
I bet there is a better method to go with. I just don't need fancy looking buttons.

 

[Snakehips]

Sorry, DropBox link does not work for me so cannot comment.

 

[9tanstaafl9]

They were originally activeX controls. I have no idea what SpillerBD means by 12 elements. And I don't need fancy buttons either, that was my second comment on this thread, that I had solved the issue by using the other kind of buttons. I'm sorry this has got out of control.

Seriously, I didn't intend to waste anyone's time. Is there a way to mark things as SOLVED so that this won't happen in the future? Often I don't get an answer to my question but after a few hours of messing around while waiting I find the answer I need.

I had just thought this was a very simple question. I'm not good with buttons, until this issue I had never really even understood why the button appeared twice and that they were two different kinds. So sorry.

 

[SpillerBD]

If you right click on a button and choose Ungroup to break it down into all the elements it is made of, you will find that it is multiple element types. This was apparently done to get the look that 2013 can achieve directly on the Button element formatting (fill and shadow effects.)
Even before Ungrouping those elements there still appears to be 2 elements one could click on, but as many layered items go, you are often selecting the one you don't want.
Waste my time? No, it taught me (and reminded) me that some solutions in the past have funny consequences for the present (and future.)
I think you had less of a "brain fart" and more of "really, it was done that way?" moment.