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).
37 Answers
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):
You can also right click on the command button, choose "command button object" and then choose "edit"
Select the Design mode on , right click properties " Alphabetic" change the name on caption to your desired name.
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.
I know this is an old question, but this answer might help others that are struggling to achieve this.
There are two types of buttons that user can add on a worksheet.
- Form Control Button
- ActiveX Control Button
1st (Form Control Button):
- If you have added the button as a Form Control via Developer tab and under the Insert -> Form Controls -> Button
Then changing the name of this type of button can be done via the address bar:
- Right click on the button and then click somewhere else to leave it in design mode and then change the name on the button in the address bar
Changing name of Form Control Button
2nd (ActiveX Control Button)
- If you have added the button as an ActiveX Control Button via Developer tab and under the Insert -> ActiveX Controls -> Button
Then changing the name can be done via properties window AND the address bar
Changing Name Of ActiveX Control Button
3rd (Changing the name via VBA) You can always use VBA to change the name of the button, you just need to access your worksheet Buttons collection and change it from there:
ActiveSheet.Buttons("Button 1").Name = "ChangeNameHere"It drove me crazy for awhile, trying this and that and suggestions. I have office 2019, and every time I right clicked on the button, I would get a Move and Copy menu and I would just click somewhere else to get out of the menu. But finally I decided to just hit Escape to rid the menu. This kept button sizing outline, and I was able to place my cursor in the middle of the button and was able to change the name. Note: Do Not Hit The Enter Key or it will erase the text and boot you out. Just click off the button.
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.
