Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to find the name of the command buttons
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to find the name of the command buttons
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 On Tue, 22 Jul 2008 06:26:05 -0700, Glenda wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to find the name of the command buttons
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. -- -SA "Glenda" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Buttons | Excel Discussion (Misc queries) | |||
Command Buttons | Excel Discussion (Misc queries) | |||
Help with command buttons | Excel Worksheet Functions | |||
command buttons | Excel Worksheet Functions | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |