用VSTO給EXCEL添加右鍵菜單項(xiàng)

歐陽(yáng)家百創(chuàng)編如何用VSTO給EXCEL添加右鍵菜單項(xiàng)歐陽(yáng)家百(2021.03.07)用VSTO操縱EXCEL使用C#語(yǔ)言開(kāi)發(fā)的添加的右鍵菜單下直的確有“MyTest"—項(xiàng)，但是點(diǎn)擊卻不能進(jìn)入OnCancelRelate_ClickEventHandler函數(shù)請(qǐng)叵)有誰(shuí)知道為什么？？代碼如下//刪掉所有名為DEL_SUB」TEM_STR的菜單項(xiàng)Microsoft.Office.Core.CommandBar cellBar =Globals.ThisWorkbook.Application.CommandBars[Hceir,];Microsoft.Office.Core.CommandBai-Controlsbars=cellBar.Controls;Microsoft.Office.Core.CommandBarControl newCtrl =bars.Add(Microsoft.Office.Core.MsoControlType.msoControlButton,missing,missing,missing,true);//newCtrl.Caption=DEL_SUB_ITEM_STR;Microsoft.Office.Core.CommandBarButtonnewBtn=newCtrlasMicrosoft.Office.Core.CommandBarButton;newBtn.Tag=nMyTestM;newBtn.Caption="MyTest";newBtn.Faceld=0163;歐陽(yáng)家百創(chuàng)編歐陽(yáng)家百創(chuàng)編newBtn.StyleMicrosoft.Office.Core.MsoButtonStyle.msoButtonCaption;newBtn.Click += newMicrosoft.Office.Core._CommandBarButtonEvents_ClickEventHandler(OnCancelRelate_ClickEventHandler);檢查你添加的右鍵菜單項(xiàng)的類型newBtn.StyleMicrosoft.Office.Core.MsoButtonStyle.msoButtonCaption;這句不要估計(jì)就行了以下是添加按鈕，并且添加事件的實(shí)例，請(qǐng)LZ參考。。。新建excel-addin程序。1、 添加引用usingOffice=Microsoft.Office.Core;usingSystem.Collections;2、 聲明對(duì)象privateExcel.ApplicationAppExcel;privateOffice.CommandBarButtonbtnCalc;歐陽(yáng)家百創(chuàng)編歐陽(yáng)家百創(chuàng)編添加代碼〃宿主啟動(dòng)時(shí)執(zhí)行?privatevoidThisAddIn_Startup(objectsender,System.EventArgse){AppExcel=Application;AddToolBar();}4、 以下是AddToolBar()方法的實(shí)現(xiàn)〃添加工具欄privatevoidAddToolBar(){Office.CommandBarsbars=AppExcel.CommandBars;if(bars==null)return;foreach(Office.CommandBarbarinbars){if(bar.Name.ToLower().Trim()=="mzbar"){bar.Delete();})Office.CommandBar mzBar =AppExcel.CommandBars.AddC'mzBar",1,null,null);if(mzBar!=null){btnCalc =(Office.CommandBarButton)mzBar.Controls.Add(Office.MsoControlType.msoControlButton,missing,missing,1,true);if(btnCalc!=null){歐陽(yáng)家百創(chuàng)編btnCalc.Caption=”計(jì)算(&C)“；btnCalc.Style =Office.MsoButtonStyle.msoButtonlconAndCaption;btnCalc.TooltipText=”計(jì)算"；btnCalc.Faceld=3277;btnCalc.Click += newMicrosoft.Office.Core._CommandBarButtonEvents_ClickEventHandler(btnCalc_Click);}mzBar.Visible=true;}}4、以下是btnCalc_Click事件的實(shí)現(xiàn)voidbtnCalc_Click(Microsoft.Office.Core.CommandBarButtonCtrl