How do I change the name of a command button in Excel
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).
Solution 1:
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):