Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

Menu for favorite macros in Excel 2011 for the Mac

I changed John Walkenbach‘s superb menu maker example for 97-2003 to create the PopUp menu on this page for Mac Excel 2011. Very easy to add and edit menu items with this technique.

Note: If you use Excel 2016 for the Mac, check out: Menu for favorite Macros in Mac Excel 2016

How do I use the Add-in in Excel 2011 for the Mac

1) Download the MyMacVBACodeMenu.dmg file with the add-in.

Double-click the dmg file if it does not mount automatically. Drag the MyMacVBACodeMenu.xlam file to the folder you want.  Tip: Use one folder for all your add-ins (easy to backup your add-ins this way )

Note: MyMacVBACodeMenu is available as freeware. But you can use the Contact button in the menu if you want to support the development of this add-in.

2. Start Excel and open a workbook.

Click Tools, click Add-Ins, use "Select" to browse to and select the add-in and then
click Open. Verify MyMacVBACodeMenu is checked in the add-in list and then click OK.

The add-in add a button in the Tools menu called My Macro Menu that call the popup menu and you can also use the shortcut CMD Alt l to call the popup menu. Note: The first item Help is not created by my code but is a bug in Mac Excel, I can't find a way to hide it sorry.

 

How do I edit the menu :

We use the shortcut CMD Alt l or Tools>My Macro Menu to open the menu and choose "Edit Menu" in the menu. You will now see the worksheet in the add-in with the menu table you see below.

Read the following information carefully:

Level: The "level" of the particular item. Valid values are 2 and 3.
Level 2 is for a menu item and 3 is for a submenu item.

Caption: The text that appears in the menu, menu item, or submenu.
Use an ampersand (&) to specify a character that will be underlined.

Macro name: For level 2 or level 3 items, this will be the macro that is executed when the item is selected. If a level 2 item has one or more level 3 items, the level 2 item may not have a macro associated with it. If you use Alt F11 to go to the VBA editor you can add or change your macros in the MacroModule.

Divider: True if a "divider" should be placed before the menu item or submenu item.

FaceID: Optional, code number that represents the built-in graphic images that is displayed,
Note
: This is not working on a Mac.

You can edit the information in the table to make your own menu. You can click on the “Refresh Menu” button on the worksheet to see if your changes are correct. When It is OK click on the "Save the Add-in" button on the worksheet to save the add-in.