Menu for favourite Macros in Mac Excel
In Mac Excel 2016 and higher we can use RibbonX now to change the Excel Ribbon on the Mac. Creating menus with RibbonX is not so easy for most Excel users and you also need to develop on a Windows machine. I create an add-in with a workbook to make it easy to create the RibbonX for your own menu and store the RibbonX in an txt file. You can do it all on your Mac this way.
Note: in the workbook that you use to edit the menu there is also an option in the Ribbon to choose the imageMso you like to use for the menu option.
Note: in the workbook that you use to edit the menu there is also an option in the Ribbon to choose the imageMso you like to use for the menu option.
You find the button to open the menu on the Home tab, it is the first button.
Download and install the add-in
Download DynamicMacMenu.zip (file date: 27-Nov-2024)
Important: Be sure that the add-in, both txt files and the workbook to edit the menu are in the same folder.
If you copy for example the folder that you download on your 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) for Both txt files, this is because of Apple’s sandbox requirements.
Important: Be sure that the add-in, both txt files and the workbook to edit the menu are in the same folder.
If you copy for example the folder that you download on your 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) for Both txt files, this is because of Apple’s sandbox requirements.
- Open Excel
- Use Tools>Excel Add-ins... in the menu to open the Add-ins dialog
- Use the Browse button to select the add-in and choose Open
- Press OK
- Done
Note: If you store the Add-in in the Add-ins folder it will be automatic in your Add-ins dialog list, read the information on this page if you want to know how to do this : Install an Excel Add-In in Excel for Mac. But it also list the excel help file that you use to edit the menu if you copy the four files in the Add-ins folder. So with this add-in it is better to use a different location for the folder with the 4 files in it.
Below the Grant File Access popup that you see the first time you press the menu button :
How do I edit the menu and use the imageMso picker
Open the Workbook(EditDynamicMacMenu.xlsm) and the Edit My Menu tab next to the Home tab is active.
Note: This workbook is only used if you want to edit the menu.
Note: This workbook is only used 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 ActiveCell.
Look at the Table and how the menu looks like and you see that it is very easy to edit. In the Example there are two buttons, and a menu with inside this menu another menu and then again a button.
When you have edit the menu you must first press the “Test Menu” button 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.
Tip: if you want to use the & character in a label you can use it like this , instead of Sort & Filter use :
Important : It is very important to close the EditDynamicMacMenu workbook before you use the menu of the add-in on the Home tab or start with adding your macro's to the add-in's macro module, this is to avoid losing the connection to the Ribbon. So if the menu is ready close the workbook and add your macro's to the add-in.