asked on
private void SetColorHandler(object sender, RibbonControlEventArgs e)
{
Excel.Workbook excelWorkBook = Globals.ThisAddIn.Application.ActiveWorkbook;
Excel.Worksheet activeWorksheet = excelWorkBook.ActiveSheet;
foreach (Excel.ChartObject chartObj in activeWorksheet.ChartObjects())
{
//Do something
}
}