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)

Syntax

'Declaration
<ComVisibleAttribute(False)> _
Public Delegate Sub AppEvents_WorkbookBeforeCloseEventHandler ( _
    Wb As Workbook, _
    <OutAttribute> ByRef Cancel As Boolean _
)
'Usage
Dim instance As New AppEvents_WorkbookBeforeCloseEventHandler(AddressOf HandlerMethod)

[ComVisibleAttribute(false)]
public delegate void AppEvents_WorkbookBeforeCloseEventHandler(
    Workbook Wb,
    out bool Cancel
)

Parameters

• Wb
  Type: Microsoft.Office.Interop.Excel.Workbook

  The workbook that's being closed.

• Cancel
  Type: System.Boolean

  False when the event occurs. If the event procedure sets this argument to True, the workbook doesn't close when the procedure is finished.

See Also

Reference

Microsoft.Office.Interop.Excel Namespace