I placed it in a private sub under the worksheet .

Private Sub Worksheet_SelectionChange(ByVal Target As Range)