This topic has not yet been rated - Rate this topic

AppEvents_Event.WorkbookNewSheet Event

Office 2003

Office 2010

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

'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

C++

event AppEvents_WorkbookNewSheetEventHandler WorkbookNewSheet;

 void add_WorkbookNewSheet(AppEvents_WorkbookNewSheetEventHandler handler);
 void remove_WorkbookNewSheet(AppEvents_WorkbookNewSheetEventHandler handler);

JScript

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

Reference

AppEvents_Event Interface
Microsoft.Office.Interop.Excel Namespace

Other Resources

AppEvents_Event Members

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD