title: Excel VBA: When I click the + beside a group of rows
body: <p>When I click the + beside a group of rows, how do I get it to hide a row outside of the grouped rows.</p>
  
  <p>I tried this but it didn't work.</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  
  If (Target.Rows(11).Hidden = True) Then
      Rows(22).EntireRow.Hidden = False
  Else
      Rows(22).EntireRow.Hidden = True
  End If
  
  End Sub
  </code></pre>