Workbook.SheetChange Event (Excel)
Occurs when cells in any worksheet are changed by the user or by an external link.
Syntax
식 .SheetChange(Sh, Target)
식 An expression that returns a Workbook object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Sh |
필수 |
Object |
A Worksheet object that represents the sheet. |
Target |
필수 |
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