Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

Dynamic Menu for your favorite macros in Excel 2007-2016

If you want to use your favorite macros in all your workbooks then you can copy the macros in your Personal.xlsb. See this page for info: How do I create and use a PERSONAL file for my VBA code

Create your own tab on the Ribbon manual(2010-2016) or with RibbonX(2007-2016), see this page Change the Ribbon in Excel 2007-2016, Note: Only in 2010-2016 you can do this in the userinterface.

And another option is to use a add-in with a nice popup menu in the Quick Access Toolbar (QAT), like I show you on this page : Menu for favorite macros in Quick Access Toolbar in Excel 2007-2016. If you are a Mac user visit this page for a Mac version for Excel 2011: http://www.rondebruin.nl/mac/addins/macvbamenu.htm

 

Or you can use the Add-in below that create a Dynamic menu on the Home tab

How do I use the Dynamic menu Add-in

In the add-in below I have add a button to the Home tab that opens a Dynamic menu. It is very easy to edit the menu because all the information for the menu is in a menu table in a sheet in the add-in. Much easier then making a custom Ribbon with RibbonX.

1) Download the zip file with the add-in Dynamic Menu for Excel for Windows (25-Nov-2015)

2) Unzip/Copy the file to a folder on your system (Use a folder that you backup sometimes).

3) Use the shortcut Alt ti or click the Microsoft Office button(2007) or File(2010-2016), click Excel options(2007) or options(2010-2016), click the Add-Ins tab. In the Manage drop-down, click Excel Add-ins, and click Go.

Use "Browse" to select the add-in and then click on OK. Verify Dynamic Menu for Excel for Windows is checked in the add-in list and then click OK.

4) If we click on the RDB Menu button on the home tab now the Dynamic menu will PopUp. Tip: You can right click on the button and choose Add to Quick Access Toolbar.

 

How do I edit the menu :

All the information you need to know you will find in the sheet with the menu Table.

You make the sheet with the menu table visible by clicking on the Change Menu button in the menu.