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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
I forgot to add, click the DESIGN MODE button after assigning the macro to
exit design mode.
 
Thank you. I created a macro and want to assign it to a button I created.
How do I do that?
 
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
 
You must log in or register to reply here.

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

Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
Assign Function to a Command Button 1
Assigning Macros in Excel 2007 1
Command Button Excel 2007 4
Assigning a command button to a macro 6
Assigning Macro to a Command Button 3
Alt+F11, writing macros and assigning to a button 2
How to assign macro coding into customized button? 4

Back
Top