Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

Menu for favorite Macros in Mac Excel 2016 and up

In Mac Excel 2016 and up we can't use the code anymore that I use on this page for Excel 2011 to create a popup menu for your favorite macros: Menu for favorite macros in Excel 2011 for the Mac

But in Mac Excel 2016 and up we can use RibbonX now to change the Excel Ribbon. Because creating menus with RibbonX is not so easy for most Excel users I create a add-in with a help workbook that makes it easy to make a menu for your favorite macros with the RibbonX in a txt file.

 

You find the buttton named Test Menu to open the menu on the Home tab.

Download and install the add-in

Note: If you are a Windows user check out this page for a version for Windows.

Download DynamicMenu-Mac.zip (file date: 15-March-2019)

Be sure that your Office install is 16.15 or higher, before that version there is a bug that installed add-ins are read-only, so you can't edit/save the code in the VBA editor.

Note : The txt file and help workbook to make the menu must be in the same location as the add-in

Install the add-in with Tools>Add-ins in the menu bar so it open each time you open Excel.

You can use a location that have no problems with Apple’s sandbox requirements, see this page for more information : http://www.rondebruin.nl/mac/mac034.htm

If you use for example a folder on the Desktop you will notice that it will ask you permission to access the txt file the first time you click on the menu button (Grant File Access Prompt), this is because of Apple’s sandbox requirements.

How do I edit the menu :

Open the Workbook(EditDynamicMenuMac.xlsm)

Note: This workbook is only if you want to edit the menu

 

After you open the help workbook there is a new tab next to the Home tab on the Ribbon named “Edit My Menu” with a few menu options. There is an option to add buttons below the activecell row and to Start a menu and End a menu and to delete the activecell row. If you have select a cell in the imageMso column you can look for the imageMso(1671) you want for that button in the Ribbon menu and if you click on the imageMso that you want then the name will be placed in the cell.

Look at the Table and how the menu looks like and you see that it is very easy.

When you have edit the menu you must first press the “Update menu txt file” button before you can press the Smiley icon to see if the menu is correct.

After it looks correct you can close the workbook and open the VBA editor to add your macros in the MacroModule of the add-in, look at the macros that are already in it so you know how you call a macro from a Ribbon button. Do not forget to click on Save in the VBE editor menu so the code is saved in the add-in.

It is also possible to add the complete xml in the VBA code but with the txt file it is easier to edit. If you have problems let me know so we can fix it.

For more information about the Mac Ribbon visit  this page : Change the Ribbon in Mac Excel 2016