This documentation is archived and is not being maintained.

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)

'Declaration
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*/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.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Show: