Syntax
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Enter
Code
End Sub
This event will run after a user edits a cell
or cells within any worksheet within this workbook. This event will occur after the Worksheet
SheetChange Event for the specific worksheet that is being changed.
Required Parameters
Sh
The sh parameter returns the worksheet that
was changed by the user. This parameter
returns a Worksheet object to allow users to manipulate the events, methods and
properties.
Target
The target parameter will return the range of
the cells where the change occurs.