Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

Menu for favorite Macros in Mac Excel 2016

In Mac Excel 2016 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 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 that makes it easy to make a menu for your favorite macros.

In the first version of the add-in I used a worksheet in the add-in for the menu information and changed the VBA IsAddin property to show the sheet but in Mac Excel 2016 this is not working correct so in the new example I use a txt file with the menu information.

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

 

Download and install the add-in (Beta version)

Download MyDynamicMenu.zip (file date: 27-Dec-2017)

Note: You find the add-in and a txt file in the zip file

 

First step :

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.

Note : The txt file must be in the same location as the add-in

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

 

Next step :

After you follow the first step en open Excel you will notice the button My Menu on the Home tab and if you click on it you see a dropdown menu. When you want to change the menu you can open the txt file with TextEdit and add xml or edit it. You can add your new macro callbacks in the MacroModule in the add-in.

It is also possible to add the complete xml in the VBA code but in 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