Workbook SheetChange Event



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.