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
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.
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: