C# VSTO给Excel添加右键菜单并添加点击的click事件

时间:2019-06-20 21:18:38   收藏:0   阅读:389
Excel.Application app;
private void ThisAddIn_Startup(object sender, System.EventArgs e)
{
    app = Globals.ThisAddIn.Application;
    Office.CommandBars bars = app.CommandBars;            
    Office.CommandBar bar = bars["cell"];  //获取右键菜单项
    bar.Reset();
    Office.CommandBarControls controls = bar.Controls;
    Office.CommandBarButton newControl =(Office.CommandBarButton)controls.Add(Office.MsoControlType.msoControlButton, missing, missing, missing, true);
    newControl.Caption = "My test";
    newControl.Click += NewControl_Click;
}

private void NewControl_Click(Office.CommandBarButton Ctrl, ref bool CancelDefault)
{
    System.Windows.Forms.MessageBox.Show("Test");
}

 

原文:https://www.cnblogs.com/huang1314wei/p/11061295.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!