Need to find the name of the command buttons

G

Glenda

I inherited a spreadsheet that contains 11 steps kicked off by command
buttons. I want the command buttons to be disabled as they are completed so
the users will not run the same process more than once. I'm not able to find
the names of the buttons to be able to reference them.
 
G

Gord Dibben

If button is a Forms button, Right-click on the button and you will see the
name up in the namebox.

If from the control toolbox, same as above or "Properties"


Gord Dibben MS Excel MVP
 
S

StumpedAgain

Try using the "Control Toolbox" (Tools->Customize...) design mode. Right
click the button and select properties. It usually gives the name of the
button. If not, you may be able to create new buttons and assign the
macros/proceedures to the new buttons and work with those.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Synchronization problems while moving folders to new email 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
Cannot open any folders (pinned or recent) from Word 365 Open Dialogue/Backstage 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Use Macro To Change Which Macro Assigned To Command Button 0
losing command button functionality 4
Two Toggle Buttons to calculate Day(s) Hour(s) Minute(s) between entry time 1
Command Button & Email Subject???? 0

Top