private void menuCommand_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault) { CommandBarButtonClass menu = (CommandBarButtonClass)Ctrl.Control; ws = (Excel.Worksheet) this.Application.ActiveSheet; wb = (Excel.Workbook) this.Application.ActiveWorkbook; //ws.Cells[1,1] = "The menu command was clicked." + menu.Tag; if (menu.Tag == menuTags.About.ToString()) { aboutClicked(); } else if (menu.Tag == menuTags.ImportData.ToString()) { importDataClicked(); } else if (menu.Tag == menuTags.InsertColumnHeader.ToString()) { insertColumnHeadingClicked(); } else if (menu.Tag == menuTags.GenerateUFL.ToString()) { generateUFLClicked(); } else if (menu.Tag == menuTags.SaveDetails.ToString()) { saveDetails(); } else if (menu.Tag == menuTags.SaveAsDetails.ToString()) { resetFileFormatId(); saveDetails(); } else if (menu.Tag == menuTags.LoadDetails.ToString()) { loadDetails(); } }
private void menuCommand_Click(Microsoft.Office.Core.CommandBarButton Ctrl, ref bool CancelDefault) { CommandBarButtonClass menu = (CommandBarButtonClass)Ctrl.Control; ws = (Excel.Worksheet) this.Application.ActiveSheet; //wb = (Excel.Workbook)this.Application.ActiveWorkbook; //ws.Cells[1,1] = "The menu command was clicked." + menu.Tag; if (menu.Tag == menuTags.UpdateData.ToString()) { updatePIData(); } else if (menu.Tag == menuTags.GetPIData.ToString()) { getPIData(); //something } else if (menu.Tag == menuTags.AboutPIDataEdit.ToString()) { aboutClicked(); } }