WorkbookEvents_Event.SheetChange EventĀ
Occurs when cells in any worksheet are changed by the user or by an external link.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)
Usage
WithEvents workbookEvents_Event1 As WorkbookEvents_Event
Function workbookEvents_Event1_SheetChange(Sh As Object, _
Target As Range) As Void
Handles workbookEvents_Event1.SheetChange
End Function
Syntax
Event SheetChange As WorkbookEvents_SheetChangeEventHandler
event WorkbookEvents_SheetChangeEventHandler SheetChange;
event WorkbookEvents_SheetChangeEventHandler^ SheetChange;
void add_SheetChange(WorkbookEvents_SheetChangeEventHandler handler);
void remove_SheetChange(WorkbookEvents_SheetChangeEventHandler handler);
In JScript, you can handle the events defined by a class, but you cannot define your own.
Remarks
This event doesn't occur on chart sheets.
Platforms
Development Platforms
Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000
Target Platforms
See Also
Reference
WorkbookEvents_Event Interface
Microsoft.Office.Interop.Excel Namespace