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

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

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

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

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

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?