Excel加载项按钮

Question

我是Excel插件编程的新手。我在C#中为Excel2010创建了一个Excel插件，它将在工作簿的每个工作表中创建按钮。

谁能告诉我这段代码出了什么问题：

Excel.Worksheet activeWorksheet = Globals.ThisAddIn.Application.ActiveWorkbook.ActiveSheet;
Microsoft.Office.Tools.Excel.Worksheet vstoWorksheet = activeWorksheet.GetVstoObject(Globals.Factory);
Excel.Range selection = vstoWorksheet.Range[2, 2];
Microsoft.Office.Tools.Excel.Controls.Button button = new Microsoft.Office.Tools.Excel.Controls.Button();
button.Tag = vstoWorksheet.Controls.AddControl(button,selection, "Click"); button.Name = "Click";
button.BackColor = System.Drawing.Color.Cyan;
button.Text = "Click";

Answer 1

我看到了问题：

button.Tag = vstoWorksheet.Controls.AddControl(button,selection, "Click"); 

应该是：

vstoWorksheet.Controls.AddControl(button,selection, "Click");