Assign Macro to command button

  • Thread starter Thread starter John Day
  • Start date Start date
J

John Day

How do I assign an existing Marco to a Command Button?

Thanks
John
 
Right click on the toolbar and select customise. Can get
to this with the "View" "Toolbar" "Customise...".

This brings up the customise box. Right click then on the
button you wish to assign a macro to. The menu then has a
place towards the bottom where the macro can be assigned.

Hope this is what you need.

BOL

DavidC
 
John

If button is from the Forms Toolbar, just right-click and "Assign macro"

If button from the Control Toolbox, right-click and "View Code"

Copy the macro in there or just reference the macro by name.

Gord Dibben 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

Assign Function to a Command Button 1
How to assign macro coding into customized button? 4
Command button macro 6
Assigning a command button to a macro 6
Assigning Macro to a Command Button 3
Command Button Excel 2007 4
how do you assign a macro to a command button in Excel 2003 5
How to identify macro assigned to toolbar button 3

Back
Top