Assigning a Macro to a Button

Q: How do I create a new button and assign a Macro to it?
A:

  • Right click on any toolbar and choose ‘Customize’.
  • Choose ‘Commands’ Tab
  • Click on ‘Custom Button’ & Drag it onto the toolbar
  • With the ‘Customize’ box still open, Right click on the dragged button & Choose Assign Macro
  • Choose the required Macro
  • Click OK
  • Optional-You may also change the Name of the Button, the Image etc. by right clicking on it with the ‘Customize’ box still open.

Possibly related posts: (automatically generated)

This entry was posted on October 1, 2006 at 5:07 pm and is filed under Macros, Microsoft Excel, Microsoft Office, Microsoft PowerPoint, Microsoft Word. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Assigning a Macro to a Button”

  1. Dave Leasure Says:
    December 28, 2007 at 3:57 pm

    Is there a way to do this in the new Excel 07 version?

  2. Vasanth Says:
    December 29, 2007 at 3:59 am

    Yes. it is possible to do it. It is simpler to do if you have the VSTO(Visual Studio Tools for Office). I’ll write a post on it shortly. .. Vasanth

Leave a Reply