The only way to change this menu up to Excel 2007 is to use VBA code, but in Excel 2010-2016 you can also change a context menu with Ribbon X. Enable Events = False End With For Each cell In Case Range cell.
Note : In Mac Office 2016 it is not possible anymore to change this menu with VBA code, Ribbon X is the only way to do it in the Mac 2016 version, Ribbon X is not working in Mac Office 2011, you need VBA code in this version.
The most common Context Menu that most people know and use is the Cell menu. You can download three example workbooks here that add a dynamic menu to the cell menu based on the username, language of Excel or the value of the active cell (Formula, Empty, Numeric or Text)You can find all the information about the example in the relevant workbook.
This is the menu that you see when you right click on a worksheet cell or selection. Calculation = Calc Mode End With End Sub Sub Lower Macro(control As IRibbon Control) Dim Case Range As Range Dim Calc Mode As Long Dim cell As Range On Error Resume Next Set Case Range = Intersect(Selection, _ Selection. Special Cells(xl Cell Type Constants, xl Text Values)) If Case Range Is Nothing Then Exit Sub With Application Calc Mode = . Note: Remember that the Ribbon X examples only work in Excel 2010-2016 Download Dynamic menu Example files Context Menus Add-In for Office 2010 : This Com add-in from Microsoft add the id Mso name of the Context Menu on the bottom of every Context menu(Right click menu's).
The screenshot below is from the Excel 2010 Cell menu. This is a very easy way for developers to find the id Mso of the menu so they can use it in the Ribbon X.
Note: On the bottom of the menu you also see the name of the id Mso of thismenu added by the Microsoft add-in discussed later in this article. Note: Only In 2010-2016 you can change the Context Menu's with Ribbon X.
Customizing Context Menus with VBA in every Excel version If you want to insert Ribbon X into a Excel 2010-2016 workbook to change the context menus, then I suggest you download and install the free Custom UI Editor on a Windows machine to make this a lot easier : I suggest that Mac developers develop on a Windows machine so they can use the Custom UI Editor.
Be aware that image Mso is not working in Mac Office 2016.
Important : Mac Excel 2016 must be version 15.17 or higher, before that Ribbon X is not working in Mac Excel 2016.
Note: It is not possible to insert Ribbon X into Excel 97-2003(xls) files.
This example will add a custom button, built-in button (Save) and a Custom menu on top of the Cell menu.
Open a new workbook and save it at as a Macro Enabled Workbook (xlsm) and close the workbook.
Open the file in the Custom UI Editor and Insert an Office 2010 Custom UI Part.