Workbook.SheetChange Event (Excel)
Occurs when cells in any worksheet are changed by the user or by an external link.
Syntax
expression .SheetChange(Sh, Target)
expression An expression that returns a Workbook object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Sh |
Required |
Object |
A Worksheet object that represents the sheet. |
Target |
Required |
Range |
The changed range. |
Remarks
This event doesn't occur on chart sheets.
Example
This example runs when any worksheet is changed.
Private Sub Workbook_SheetChange(ByVal Sh As Object, _
ByVal Source As Range)
' runs when a sheet is changed
End Sub