/// <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;
}
}
