1

I am new to Excel addin programming. I created an Excel addin for Excel 2010 in C# which will create button in every sheet of workbook.

Can some one tell me what is wrong with this code:

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";
Jesse
  • 1,937
  • 3
  • 19
  • 28
Abhinav
  • 55
  • 1
  • 7
  • 1
    Microsoft has a whole website about it here http://msdn.microsoft.com/en-us/office/hh133430.aspx – Jesse Jun 12 '12 at 16:54
  • 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"; Can some one tell me what is wrong with this code. – Abhinav Jun 14 '12 at 05:39

1 Answers1

0

I see the problem:

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

Should be:

vstoWorksheet.Controls.AddControl(button,selection, "Click");
Jeremy Thompson
  • 61,933
  • 36
  • 195
  • 321