title: Control double click event for row header
body: <p>So I'm pretty familiar with referencing worksheet ranges for worksheet events such as double click. In this case though, I'm looking to reference when the row header gets double clicked instead of a cell. It would still be specific to a worksheet but I've been unsuccessful thus far. </p>
  
  <p>I have multiple ranges that do different events on double clicks so I use code similar to the example below:</p>
  
  <pre><code>Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
      Dim rWatchRange As Range
      Dim sWatchRange As Range
  
      Set rWatchRange = Range("A5:A1000")
  
      'I somehow need it to recognize if the row header is 
      'double clicked between row 5 and 1000 to fire off the second sub
  
      Set sWatchRange = Range("5:1000")
  
  
      If Not Application.Intersect(Target, rWatchRange) Is Nothing Then
          Run "aFormattingSub"
      End If
  
      If Not Application.Intersect(Target, sWatchRange) Is Nothing Then
          Run "aSubToInsertNewLineAndGroupWithRowAbove"
      End If      
  End Sub
  </code></pre>
  
  <p>I'm not sure if there is a worksheet reference, application reference or a setting in Excel that I'm aware of that can do this.</p>