AppEvents_WorkbookBeforeCloseEventHandler Delegate
A Delegate type used to add an event handler for the WorkbookBeforeClose event. The WorkbookBeforeClose event occurs immediately before any open workbook closes.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)
Usage
Sub Sub1(Wb As Workbook, _
Cancel As Boolean)
End Sub
Dim appEvents_WorkbookBeforeCloseEventHandler1 As New AppEvents_WorkbookBeforeCloseEventHandler(AddressOf Sub1)
Syntax
Public Delegate Sub AppEvents_WorkbookBeforeCloseEventHandler( _
<InAttribute()> ByVal Wb As Workbook, _
<InAttribute(), OutAttribute()> ByRef Cancel As Boolean _
)
public delegate void AppEvents_WorkbookBeforeCloseEventHandler(
[In] Workbook Wb,
[In, Out] ref bool Cancel
);
public delegate Void AppEvents_WorkbookBeforeCloseEventHandler(
Workbook^ Wb,
&Boolean Cancel
);
public delegate void AppEvents_WorkbookBeforeCloseEventHandler(
/*in*/Workbook Wb,
/*in*/boolean Cancel
);
In JScript, you can use the delegates in the .NET Framework, but you cannot define your own.
Parameters
- Wb
The workbook that's being closed.
- Cancel
False when the event occurs. If the event procedure sets this argument to True, the workbook doesn't close when the procedure is finished.
Platforms
Development Platforms
Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000