/// <summary> /// /// </summary> /// <param name="cbar"> commandBar on which the button is added.</param> /// <param name="tag"> button tag</param> /// <param name="desc">button description</param> /// <param name="caption">button caption</param> /// <param name="before"></param> /// <param name="temp"></param> /// <param name="handler"></param> /// <param name="parameter"></param> /// <returns></returns> public static CommandBarButton addButton(CommandBar cbar, String tag, String desc, String caption, Object before, bool temp, _CommandBarButtonEvents_ClickEventHandler handler, String parameter) { CommandBarButton foundButton = (CommandBarButton)cbar.FindControl( MsoControlType.msoControlButton, Type.Missing, tag, false, true); if (foundButton != null) { foundButton.Caption = caption; setClickHandler(foundButton, handler); foundButton.Visible = true; foundButton.Parameter = parameter; return foundButton; } CommandBarButton button = (CommandBarButton)cbar.Controls.Add( MsoControlType.msoControlButton, Type.Missing, Type.Missing, before, temp); setClickHandler(button, handler); button.Tag = tag; button.DescriptionText = desc; button.BeginGroup = false; button.Caption = caption; button.Style = MsoButtonStyle.msoButtonIconAndCaption; button.Visible = true; button.Parameter = parameter; return button; }
/// <summary> /// /// </summary> /// <param name="theBar"></param> /// <param name="tag"></param> public static void RemoveButton(CommandBar theBar, String tag) { try { CommandBarButton foundButton = (CommandBarButton) theBar.FindControl(MsoControlType.msoControlButton, Type.Missing, tag, true, true); if (foundButton != null) { foundButton.Delete(false); foundButton = null; } } catch (System.Exception ex) { Logger.WriteEntry(LogLevel.Warning, ex.GetType() + ":" + ex.Message); } }
private CommandBarControl GetControl(CommandBar bar, string tag) { Object missing = Missing.Value; return bar.FindControl(missing, missing, tag, missing, missing); }
//************************************************************************* // Method: AddContextMenuSeparator() // /// <summary> /// Adds or removes a separator at the top of the context menu that appears /// when a cell is right-clicked in the edge or vertex table. /// </summary> /// /// <param name="oTableContextCommandBar"> /// The context menu that appears when you right-click a table (ListObject) /// cell. /// </param> /// /// <param name="bAdd"> /// true to add the separator, false to remove it. /// </param> //************************************************************************* protected void AddContextMenuSeparator( CommandBar oTableContextCommandBar, Boolean bAdd ) { Debug.Assert(oTableContextCommandBar != null); AssertValid(); // The button at the top of Excel's standard menu is Cut. const Int32 CutCommandID = 21; CommandBarButton oCutButton = (CommandBarButton)oTableContextCommandBar.FindControl( Missing.Value, CutCommandID, Missing.Value, Missing.Value, false); if (oCutButton != null) { oCutButton.BeginGroup = bAdd; } }