13

I feel like such a dunce, but I cannot figure out how/where to do this.

I've pasted a command button into a sheet and it came in with a default name of "Button 1". I cannot figure out where in the interface to go to change the button's name. (I can change the button's label text, I'm actually interested in renaming the button itself).

I've tried clicking "Design Mode" in the Developer Ribbon, but that does not seem to give me any additional interfaces or options for setting the button's attributes.

Help! (FYI: using Excel 2010).

3
  • click on the Properties button to the left of the Design Mode button. then click the object you want to rename – Brad Jan 14 '13 at 19:18
  • @Brad, thanks. I tried that (I hadn't tried clicking Properties, then the Button, so you've moved me forward). However, when I click Properties (to the right of the Design Mode icon), then click the button, it doesn't show me properties for the button. Instead, it shows me properties for Module1. I've tried dropping down the list in properties combo box, to see if the button is listed, but it's not. What next, do you know? Thanks! – DWright Jan 14 '13 at 19:32
  • 1
    This question is answered, but here's an important addendum: There is a 32-character limit on the length of Command Button names. The behavior if you enter a name longer than 32 characters is that Excel seems to ignore your input—no error message is given, but your changes are rolled back. When this happened to me, I thought there must be some other panel or setting I needed to use, maybe there was some workbook corruption, etc. Once I figured out that the issue was just the name length, I experimented to confirm that on Excel 2010, 32 is the maximum length. – Cory Salveson May 10 '13 at 14:47
14

You can change the name of the button (as well as any other object/chart) by selecting and typing in the small Name box left of the formula bar (confirm it by pressing Enter):

enter image description here

2
  • This is the only solution that is actually working, at least with Excel 2007. – Kar.ma Feb 28 '18 at 9:04
  • This does not work at all for me. The field is not editable – rpaulin56 Jun 16 '18 at 10:30
0

You can also right click on the command button, choose "command button object" and then choose "edit"

0

Select the Design mode on , right click properties " Alphabetic" change the name on caption to your desired name.

0

It may be that you're trying to name the button the same name as one of your procedures or a cell reference or possibly something else that already exists; otherwise, you should be able to right-click you button to select then change the name in the name box left of the formula bar.

-1

A couple of years removed, but click on design node then click on your button, and you will get bars, right click and click properties, change the name in "caption" to the one you want it to be, click the "X", then click design mode again.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.