AppEvents_Event.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

WithEvents appEvents_Event1 As AppEvents_Event
Function appEvents_Event1_WorkbookNewSheet(Wb As Workbook, _
    Sh As Object) As Void
    Handles appEvents_Event1.WorkbookNewSheet
End Function

Syntax

Event WorkbookNewSheet As AppEvents_WorkbookNewSheetEventHandler
event AppEvents_WorkbookNewSheetEventHandler WorkbookNewSheet;
event AppEvents_WorkbookNewSheetEventHandler^ WorkbookNewSheet;
 void add_WorkbookNewSheet(AppEvents_WorkbookNewSheetEventHandler handler);
 void remove_WorkbookNewSheet(AppEvents_WorkbookNewSheetEventHandler handler);
In JScript, you can handle the events defined by a class, but you cannot define your own.

Platforms

Development Platforms

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

Target Platforms

See Also

Reference

AppEvents_Event Interface
Microsoft.Office.Interop.Excel Namespace

Other Resources

AppEvents_Event Members