how do you assign a macro to a command button in Excel 2003

G

Guest

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.
 
G

Guest

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

Guest

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

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
 

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

Assign Function to a Command Button 1
Command Button Excel 2007 4
Command button macro 6
Applying a macro to a command button, Excel 2002 3
Excel 2003 - assign macro to custom toolbar button 1
Excel 2007 -- Assign a macro to a button 1
Assign a macro to a command button 4
Command Button for Macro on a Toolbar 7

Top