Excel workbook event handlers : Excel : Windows C# Examples

    
using  System;
using  Excel;
using  System.Reflection;

public  class  MainClass
{
    public  static  AppEvents_WorkbookBeforeCloseEventHandler  Event_BeforeBookClose;
    public  static  DocEvents_ChangeEventHandler  Event_ChangeEvent;
    public  static  void  Main(string[]  args)
    {
        Application  excelApp  =  new  ApplicationClass();
        Workbook  MyWorkbook  =  excelApp.Workbooks.Add(Missing.Value);

        MyWorkbook.Windows.get_Item(1).Caption  =  "Using  Delegates";

        Worksheet  MyWorksheet1  =  (Worksheet)MyWorkbook.Worksheets.get_Item(1);
        Worksheet  MyWorksheet2  =  (Worksheet)MyWorkbook.Worksheets.get_Item(2);
        Worksheet  MyWorksheet3  =  (Worksheet)MyWorkbook.Worksheets.get_Item(3);

        MyWorksheet1.Activate();

        Event_BeforeBookClose  =  new  AppEvents_WorkbookBeforeCloseEventHandler(BeforeBookClose);
        excelApp.WorkbookBeforeClose  +=  Event_BeforeBookClose;

        Event_ChangeEvent  =  new  DocEvents_ChangeEventHandler(CellChange);
        MyWorksheet1.Change  +=  Event_ChangeEvent;
        MyWorksheet2.Change  +=  Event_ChangeEvent;
        MyWorksheet3.Change  +=  Event_ChangeEvent;
        excelApp.Visible  =  true;
        excelApp.UserControl  =  true;
    }
    private  static  void  CellChange(Range  Target)
    {
        MessageBox.Show("cell  changed");
    }
    private  static  void  BeforeBookClose(Workbook  MyWorkbook,  ref  bool  Cancel)
    {
        MessageBox.Show("before  closing  a  workbook");
    }
}