| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you assign a macro to a command button in Excel 2003
how do you assign a macro to a command button in Excel 2003
-- NS |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you assign a macro to a command button in Excel 2003
Click VIEW in the menu and select TOOLBARS. In the list of available
toolbars select the CONTROL TOOLBOX toolbar. Click the first button on the toolbar, the one with the pencil, triangle & ruler, to activate design mode. Right-click the command button and select VIEW CODE. You can either write the macro or assign an existing one to the buttons Click event. -- Kevin Backmann "ns" wrote: how do you assign a macro to a command button in Excel 2003 -- NS |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you assign a macro to a command button in Excel 2003
I forgot to add, click the DESIGN MODE button after assigning the macro to
exit design mode. -- Kevin Backmann "ns" wrote: how do you assign a macro to a command button in Excel 2003 -- NS |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you assign a macro to a command button in Excel 2003
r-click it and view code.
ns wrote: how do you assign a macro to a command button in Excel 2003 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you assign a macro to a command button in Excel 2003
Thank you. I created a macro and want to assign it to a button I created.
How do I do that? -- NS "Kevin B" wrote: I forgot to add, click the DESIGN MODE button after assigning the macro to exit design mode. -- Kevin Backmann "ns" wrote: how do you assign a macro to a command button in Excel 2003 -- NS |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you assign a macro to a command button in Excel 2003
Is the button from the Control Toolbox.
Follow Kevin's instructions. If button from the Forms Toolbar just right-click on it and "Assign macro". Gord Dibben MS Excel MVP On Thu, 25 Oct 2007 11:32:36 -0700, ns wrote: Thank you. I created a macro and want to assign it to a button I created. How do I do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create a command button, then assign macro to it in excel | Excel Discussion (Misc queries) | |||
| How do I assign a macro to a command button in excel, office 2003 | Excel Discussion (Misc queries) | |||
| Assign a macro to a command button | Excel Discussion (Misc queries) | |||
| Assign a macro to Command Button Object | Excel Discussion (Misc queries) | |||
| How do I assign a macro I have created to a Command Button in Exc. | Excel Discussion (Misc queries) | |||
Linear Mode
