WorkbookEvents_BeforeSaveEventHandler Delegate

  • Article

A Delegate type used to add an event handler for the BeforeSave event. The BeforeSave event occurs before the 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 WorkbookEvents_BeforeSaveEventHandler ( _
    SaveAsUI As Boolean, _
    <OutAttribute> ByRef Cancel As Boolean _
)
'Usage
Dim instance As New WorkbookEvents_BeforeSaveEventHandler(AddressOf HandlerMethod)

[ComVisibleAttribute(false)]
public delegate void WorkbookEvents_BeforeSaveEventHandler(
    bool SaveAsUI,
    out bool Cancel
)

Parameters

  • 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