Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 1 down vote favorite

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).

share|improve this question
click on the Properties button to the left of the Design Mode button. then click the object you want to rename – Brad Jan 14 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 at 19:32

2 Answers

up vote 3 down vote accepted

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:

enter image description here

share|improve this answer
Thank you. That's what I was missing. Somehow my eye never went to the name box. The screen shot was exactly what I needed to see. – DWright Jan 14 at 19:39
You're most welcome! – Peter Albert Jan 14 at 19:51
up vote 0 down vote

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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