none
Connect a macro to button that will lead to addition button like sort & filter in Excel RRS feed

  • Question

  • Hi,

    I would like to assign macro to various button but I want them to appear under a main button. For example like the sort & filter button in Excel.


    Guy Zommer
    Thursday, December 1, 2011 3:16 PM

Answers

  • Below an idea on how to accomplish this:

    http://www.rondebruin.nl/qat2.htm

     

    Or you create your own customized ribbon, for more info see below thread:

    http://www.rondebruin.nl/ribbon.htm

     

    Hope this helps,

     


    Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"
    • Proposed as answer by Shasur Tuesday, December 6, 2011 9:09 AM
    • Marked as answer by danishaniModerator Friday, January 27, 2012 7:43 PM
    Thursday, December 1, 2011 10:41 PM
    Moderator
  • I'm not sure if this is what you're after but you can customize the ribbon.

    Click on the tab you wish you're button to appear (Home).  Right click and choose customize the ribbon. Choices at the bottom right of the screen (in Excel 2010) are New Tab, New group, Rename, Reset, Import/Emport. Click New Group.

    Now at the top left there is a box labeled choose commands from (the default is popular commands). Click on the arrow and drag down to choose commands from Macros. Your Macro should appear in this list. Highlight the macro you want your user to run and then click  Add>> (previously greyed out). Choices were Add> > Remove<<.

    Now click Ok. You should see your Macro button on the right-hand side of the ribbon.

    You can rename both the group and the Macro button if you wish. The name of the group you created is named by default New Group.

    Friday, December 16, 2011 4:11 PM

All replies

  • Hi,

    I would like to assign macro to various button but I want them to appear under a main button. For example like the sort & filter button in Excel.


    Guy Zommer
    Thursday, December 1, 2011 3:16 PM
  • Below an idea on how to accomplish this:

    http://www.rondebruin.nl/qat2.htm

     

    Or you create your own customized ribbon, for more info see below thread:

    http://www.rondebruin.nl/ribbon.htm

     

    Hope this helps,

     


    Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"
    • Proposed as answer by Shasur Tuesday, December 6, 2011 9:09 AM
    • Marked as answer by danishaniModerator Friday, January 27, 2012 7:43 PM
    Thursday, December 1, 2011 10:41 PM
    Moderator
  • I'm not sure if this is what you're after but you can customize the ribbon.

    Click on the tab you wish you're button to appear (Home).  Right click and choose customize the ribbon. Choices at the bottom right of the screen (in Excel 2010) are New Tab, New group, Rename, Reset, Import/Emport. Click New Group.

    Now at the top left there is a box labeled choose commands from (the default is popular commands). Click on the arrow and drag down to choose commands from Macros. Your Macro should appear in this list. Highlight the macro you want your user to run and then click  Add>> (previously greyed out). Choices were Add> > Remove<<.

    Now click Ok. You should see your Macro button on the right-hand side of the ribbon.

    You can rename both the group and the Macro button if you wish. The name of the group you created is named by default New Group.

    Friday, December 16, 2011 4:11 PM
  • Hi Guy Zommer,

     

    How about the problem on your side? Do you still need any assistant about the problem?

    Are the answers given helpful?

     

    If you still show any concern on the problem, just feel free to let us know.
     
    Best Regards,


    Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"
    Friday, January 20, 2012 6:27 AM
    Moderator