AppEvents_WorkbookBeforeSaveEventHandler Delegate

A Delegate type used to add an event handler for the WorkbookBeforeSave event. The WorkbookBeforeSave event occurs before any open workbook is saved.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

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

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

Parameters

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

  The workbook.

• SaveAsUI
  Type: System.Boolean

  True if the Save As dialog box will be displayed.

• Cancel
  Type: System.Boolean

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

See Also

Reference

Microsoft.Office.Interop.Excel Namespace