VSTO (document level): individual context menu in Excel (context menu)

Question

Is it possible to disable or configure the context menu (cell, range) via C # (VSTO). If so, how can I implement it (in an application at the document level of VSTO Excel)

For example, I want to disable some items in the context menu (for example, copy / paste) and add new items or replace the standard context menu with a full own menu!

Are smarttags a good alternative to context menus in Excel?

Answer 1

• Here is an example of rough code with comments
• It was created in VS2010 and tested against Excel 2010.
• The first step was to create a new Excel 2010 Add-In project.
• Then the sample code is added below the code created inside ThisAddin.cs .
• This code will add a new menu item and delete the cut / copy / paste menu items when you right-click on one cell containing "abc". This should simulate changing the context menu based on the contents of the cell.

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Xml.Linq; using Excel = Microsoft.Office.Interop.Excel; using Office = Microsoft.Office.Core; using Microsoft.Office.Tools.Excel; using System.Diagnostics; using Microsoft.Office.Interop.Excel; namespace Excel_Menu { public partial class ThisAddIn { private void ThisAddIn_Startup(object sender, System.EventArgs e) { ResetCellMenu(); // reset the cell context menu back to the default // Call this function is the user right clicks on a cell this.Application.SheetBeforeRightClick+=new Excel.AppEvents_SheetBeforeRightClickEventHandler(Application_SheetBeforeRightClick); } private void ThisAddIn_Shutdown(object sender, System.EventArgs e) { } private Office.CommandBar GetCellContextMenu() { return this.Application.CommandBars["Cell"]; } private void ResetCellMenu() { GetCellContextMenu().Reset(); // reset the cell context menu back to the default } private void Application_SheetBeforeRightClick(object Sh, Range Target, ref bool Cancel) { ResetCellMenu(); // reset the cell context menu back to the default if (Target.Cells.Count == 1) // sample code: if only a single cell is selected { if (Target.Cells[1, 1].Value == "abc") // sample code: if the signle cell contains 'abc' { AddExampleMenuItem(); RemoveCutCopyPasteMenuItems(); } } } private void AddExampleMenuItem() { Office.MsoControlType menuItem = Office.MsoControlType.msoControlButton; Office.CommandBarButton exampleMenuItem = (Office.CommandBarButton)GetCellContextMenu().Controls.Add(menuItem, missing, missing, 1, true); exampleMenuItem.Style = Office.MsoButtonStyle.msoButtonCaption; exampleMenuItem.Caption = "Example Menu Item"; exampleMenuItem.Click += new Microsoft.Office.Core._CommandBarButtonEvents_ClickEventHandler(exampleMenuItemClick); } private void RemoveCutCopyPasteMenuItems() { Office.CommandBar contextMenu = GetCellContextMenu(); for (int i = contextMenu.Controls.Count; i > 0; i--) { Office.CommandBarControl control = contextMenu.Controls[i]; if (control.Caption == "Cu&t") control.Delete(); // Sample code: remove cut menu item else if (control.Caption == "&Copy") control.Delete(); // Sample code: remove copy menu item else if (control.accDescription.Contains("Paste")) control.Delete(); // Sample code: remove any paste menu items } } void exampleMenuItemClick(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault) { System.Windows.Forms.MessageBox.Show("Example Menu Item clicked"); } #region VSTO generated code /// /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// private void InternalStartup() { this.Startup += new System.EventHandler(ThisAddIn_Startup); this.Shutdown += new System.EventHandler(ThisAddIn_Shutdown); } #endregion } }