C# - Snippets

Event_App_NewWorkbook

public void AppEvents_NewWorkbook(Excel.Workbook Wb)
{
    WbkEvents = (Excel.Workbook)gApplicationExcel.ActiveWorkbook;

    if (mbFireEvents == true)
        AppEventsNewWorkbook_Event?.Invoke();
}

Event_App_SheetBeforeRightClick

public void AppEvents_SheetBeforeRightClick(object Sh, Excel.Range Target, ref bool Cancel)
{
    if (mbFireEvents == true)
        AppEventsSheetBeforeRightClick_Event?.Invoke(Sh, Target, Cancel);
}

Event_App_SheetDeactivate

public void AppEvents_SheetDeactivate(object Sh)
{
    if (mbFireEvents == true)
        AppEventsSheetDeactivate_Event?.Invoke(Sh);
}

Event_App_WindowDeactivate

public void AppEvents_WindowDeactivate(Excel.Workbook Wb, Excel.Window Wn)
{
    if (mbFireEvents == true)
        AppEventsWindowDeactivate_Event?.Invoke(Wb, Wn);
}

Event_App_WindowResize

public void AppEvents_WindowResize(Excel.Workbook Wb, Excel.Window Wn)
{
    if (mbFireEvents == true)
        AppEventsWindowResize_Event?.Invoke(Wb, Wn);
}

Event_App_WorkbookAddinInstall

public void AppEvents_WorkbookAddinInstall(Excel.Workbook Wb)
{
    if (mbFireEvents == true)
        AppEventsWorkbookAddinInstall_Event?.Invoke(Wb);
}

Event_App_WorkbookAddinUninstall

public void AppEvents_WorkbookAddinUninstall(Excel.Workbook Wb)
{
    if (mbFireEvents == true)
        AppEventsWorkbookAddinUninstall_Event?.Invoke(Wb);
}

Event_App_WorkbookBeforeClose

public void AppEvents_WorkbookBeforeClose(Excel.Workbook Wb, ref bool Cancel)
{
    if (mbFireEvents == true)
        AppEventsWorkbookBeforeClose_Event?.Invoke(Wb, Cancel);
}

Event_App_WorkbookBeforePrint

public void AppEvents_WorkbookBeforePrint(Excel.Workbook Wb, ref bool Cancel)
{
    if (mbFireEvents == true)
        AppEventsWorkbookBeforePrint_Event?.Invoke(Wb, Cancel);
}

Event_App_WorkbookBeforeSave

public void AppEvents_WorkbookBeforeSave(Excel.Workbook Wb, bool SaveAsUI, ref bool Cancel)
{
    if (mbFireEvents == true)
        AppEventsWorkbookBeforeSave_Event?.Invoke(Wb, SaveAsUI, Cancel);
}

Event_App_WorkbookDeactivate

public void AppEvents_WorkbookDeactivate(Excel.Workbook Wb)
{
    if (mbFireEvents == true)
        AppEventsWorkbookDeactivate_Event?.Invoke(Wb);
}

Event_App_WorkbookNewSheet

public void AppEvents_WorkbookNewSheet(Excel.Workbook Wb, object Sh)
{

    // chart sheets ??
    WshEvents = (Excel.Worksheet)gApplicationExcel.ActiveSheet;

    if (mbFireEvents == true)
        AppEventsWorkbookNewSheet_Event?.Invoke(Wb, Sh);
}

Event_App_WorkbookOpen

public void AppEvents_WorkbookOpen(Excel.Workbook Wb)
{
    WbkEvents = (Excel.Workbook)gApplicationExcel.ActiveWorkbook;

    // chart sheets ??
    WshEvents = (Excel.Worksheet)gApplicationExcel.ActiveSheet;

    if (mbFireEvents == true)
        AppEventsWorkbookOpen_Event?.Invoke(Wb);
}

Event_App_WorkbookPivotTableCloseConnection

public void AppEvents_WorkbookPivotTableCloseConnection(Excel.Workbook Wb, Excel.PivotTable Target)
{
    if (mbFireEvents == true)
        AppEventsWorkbookPivotTableCloseConnection_Event?.Invoke(Wb, Target);
}

Event_App_WorkbookPivotTableOpenConnection

public void AppEvents_WorkbookPivotTableOpenConnection(Excel.Workbook Wb, Excel.PivotTable Target)
{
    if (mbFireEvents == true)
        AppEventsWorkbookPivotTableOpenConnection_Event?.Invoke(Wb, Target);
}

Workbook_Activate

private void WbkEvents_WorkbookActivate()
{
    if (mbFireEvents == true)
        WbkEventsActivate_Event?.Invoke();
}

Workbook_AddinInstall

private void WbkEvents_AddinInstall()
{
    if (mbFireEvents == true)
        WbkEventsAddinInstall_Event?.Invoke();
}

Workbook_AddinUninstall

private void WbkEvents_AddinUninstall()
{
    if (mbFireEvents == true)
        WbkEventsAddinUninstall_Event?.Invoke();
}

Workbook_BeforeClose

private void WbkEvents_BeforeClose(ref bool Cancel)
{
    if (mbFireEvents == true)
        WbkEventsBeforeClose_Event?.Invoke(Cancel);
}

Workbook_BeforePrint

private void WbkEvents_BeforePrint(ref bool Cancel)
{
    if (mbFireEvents == true)
        WbkEventsBeforePrint_Event?.Invoke(Cancel);
}

Workbook_BeforeSave

private void WbkEvents_BeforeSave(bool SaveAsUI, ref bool Cancel)
{
    if (mbFireEvents == true)
        WbkEventsBeforeSave_Event?.Invoke(SaveAsUI, Cancel);
}

Workbook_Deactivate

private void WbkEvents_Deactivate()
{
    if (mbFireEvents == true)
        WbkEventsDeactivate_Event?.Invoke();
}

Workbook_NewSheet

private void WbkEvents_NewSheet(object Sh)
{
    if (mbFireEvents == true)
        WbkEventsNewSheet_Event?.Invoke(Sh);
}

Workbook_Open

private void WbkEvents_Open()
{
    if (mbFireEvents == true)
        WbkEventsOpen_Event?.Invoke();
}

Workbook_PivotTableCloseConnection

private void WbkEvents_PivotTableCloseConnection(Excel.PivotTable Target)
{
    if (mbFireEvents == true)
        WbkEventsPivotTableCloseConnection_Event?.Invoke(Target);
}

Workbook_PivotTableOpenConnection

private void WbkEvents_PivotTableOpenConnection(Excel.PivotTable Target)
{
    if (mbFireEvents == true)
        WbkEventsPivotTableOpenConnection_Event?.Invoke(Target);
}

Workbook_SheetActivate

private void WbkEvents_SheetActivate(object Sh)
{
    if (mbFireEvents == true)
        WbkEventsSheetActivate_Event?.Invoke(Sh);
}

Workbook_SheetBeforeDoubleClick

private void WbkEvents_SheetBeforeDoubleClick(object Sh, Excel.Range Target, ref bool Cancel)
{
    if (mbFireEvents == true)
        WbkEventsSheetBeforeDoubleClick_Event?.Invoke(Sh, Target, Cancel);
}

Workbook_SheetCalculate

private void WbkEvents_SheetCalculate(object Sh)
{
    if (mbFireEvents == true)
        WbkEventsSheetCalculate_Event?.Invoke(Sh);
}

Workbook_SheetChange

private void WbkEvents_SheetChange(object Sh, Excel.Range Target)
{
    if (mbFireEvents == true)
        WbkEventsSheetChange_Event?.Invoke(Sh, Target);
}

Workbook_SheetFollowHyperlink

private void WbkEvents_SheetFollowHyperlink(object Sh, Excel.Hyperlink Target)
{
    if (mbFireEvents == true)
        WbkEventsSheetFollowHyperlink_Event?.Invoke(Sh, Target);
}

Workbook_SheetPivotTableUpdate

private void WbkEvents_SheetPivotTableUpdate(object Sh, Excel.PivotTable Target)
{
    if (mbFireEvents == true)
        WbkEventsSheetPivotTableUpdate_Event?.Invoke(Sh, Target);
}

Workbook_SheetSelectionChange

private void WbkEvents_SheetSelectionChange(object Sh, Excel.Range Target)
{
    if (mbFireEvents == true)
        WbkEventsSheetSelectionChange_Event?.Invoke(Sh, Target);
}

Workbook_WindowActivate

private void WbkEvents_WindowActivate(Excel.Window Wn)
{
    if (mbFireEvents == true)
        WbkEventsWindowActivate_Event?.Invoke(Wn);
}

Worksheet_Activate

public void WshEvents_Activate()
{
    if (mbFireEvents == true)
        WshEventsActivate_Event?.Invoke();
}

Worksheet_BeforeDoubleClick

public void WshEvents_BeforeDoubleClick(Excel.Range Target, ref bool Cancel)
{
    if (mbFireEvents == true)
        WshEventsBeforeDoubleClick_Event?.Invoke(Target, Cancel);
}

Worksheet_BeforeRightClick

public void WshEvents_BeforeRightClick(Excel.Range Target, ref bool Cancel)
{
    if (mbFireEvents == true)
        WshEventsBeforeRightClick_Event?.Invoke(Target, Cancel);
}

Worksheet_Calculate

private void WshEvents_Calculate()
{
    if (mbFireEvents == true)
        WshEventsCalculate_Event?.Invoke();
}

Worksheet_Change

public void WshEvents_Change(Excel.Range Target)
{
    if (mbFireEvents == true)
        WshEventsChange_Event?.Invoke(Target);
}

Worksheet_Deactivate

public void WshEvents_Deactivate()
{
    if (mbFireEvents == true)
        WshEventsDeactivate_Event?.Invoke();
}

Worksheet_FollowHyperlink

public void WshEvents_FollowHyperlink(Excel.Hyperlink Target)
{
    if (mbFireEvents == true)
        WshEventsFollowHyperlink_Event?.Invoke(Target);
}

Worksheet_PivotTableUpdate

public void WshEvents_PivotTableUpdate(Excel.PivotTable Target)
{
    if (mbFireEvents == true)
        WshEventsPivotTableUpdate_Event?.Invoke(Target);
}

Worksheet_SelectionChange

public void WshEvents_SelectionChange(Excel.Range Target)
{
    if (mbFireEvents == true)
        WshEventsSelectionChange_Event?.Invoke(Target);
}