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

 

[Kevin B]

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 B]

I forgot to add, click the DESIGN MODE button after assigning the macro to
exit design mode.

 

[Bob I]

r-click it and view code.

 

[ns]

Thank you. I created a macro and want to assign it to a button I created.
How do I do that?

 

[Gord Dibben]

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