Syntax
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Enter
Code
End Sub
This event will run code when a user selects
a new range within any worksheet in this specific workbook. This event will occur after the Worksheet
SheetSelectionChange Event for the worksheet that contains the newly selected
range.
Required Parameters
Sh
The sh parameter returns the worksheet that
contains the range that was selected. 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 of the new selection.
