Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

AppEvents_WorkbookNewSheetEventHandler Delegate 

A Delegate type used to add an event handler for the WorkbookNewSheet event. The WorkbookNewSheet event occurs when a new sheet is created in any open workbook.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

'Usage
Sub Sub1(Wb As Workbook, _
	Sh As Object)
End Sub
Dim appEvents_WorkbookNewSheetEventHandler1 As New AppEvents_WorkbookNewSheetEventHandler(AddressOf Sub1)

'Declaration
Public Delegate Sub AppEvents_WorkbookNewSheetEventHandler( _
	<InAttribute()> ByVal Wb As Workbook, _
	<InAttribute()> ByVal Sh As Object _
)
public delegate void AppEvents_WorkbookNewSheetEventHandler(
	/*in*/Workbook Wb, 
	/*in*/System.Object Sh
);
In JScript, you can use the delegates in the .NET Framework, but you cannot define your own.

Parameters

Wb

The workbook.

Sh

The new sheet.

Development Platforms

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

Target Platforms

Community Additions

ADD
Show:
© 2015 Microsoft