This documentation is archived and is not being maintained.

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

Sub Sub1(Wb As Workbook, _
	SaveAsUI As Boolean, _
	Cancel As Boolean)
End Sub
Dim appEvents_WorkbookBeforeSaveEventHandler1 As New AppEvents_WorkbookBeforeSaveEventHandler(AddressOf Sub1)

Public Delegate Sub AppEvents_WorkbookBeforeSaveEventHandler( _
	<InAttribute()> ByVal Wb As Workbook, _
	<InAttribute()> ByVal SaveAsUI As Boolean, _
	<InAttribute(), OutAttribute()> ByRef Cancel As Boolean _
public delegate void AppEvents_WorkbookBeforeSaveEventHandler(
	/*in*/Workbook Wb, 
	/*in*/boolean SaveAsUI, 
	/*in*/boolean Cancel
In JScript, you can use the delegates in the .NET Framework, but you cannot define your own.



The workbook.


True if the Save As dialog box will be displayed.


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

Development Platforms

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

Target Platforms