title: Show/Hide Rows Depending on Dropdown Selection
body: <p>This is the first time I'm working with Macros.
  I've created a dropdown in B2 with a "Yes" and "No" options.</p>
  
  <ul>
  <li>If User selects "Yes", Row 10 Shows / Row 11 Hides</li>
  <li>If User Selects "No", Row 11 Shows / Row 10 Hides</li>
  </ul>
  
  <p>I used this code:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Address = "$B$2" Then
  If Range("B2") = Yes Then
      ActiveSheet.Rows("10:10").EntireRow.Hidden = False
      ActiveSheet.Rows("11:11").EntireRow.Hidden = True
  ElseIf Range("B2") = No Then
      ActiveSheet.Rows("10:10").EntireRow.Hidden = True
      ActiveSheet.Rows("11:11").EntireRow.Hidden = False
  End If
  End If
  End Sub
  </code></pre>
  
  <p>I Created a new Module in <strong>Sheet1</strong>, and put it there. I saved the excel as a <em>Macro Enabled Tamplate</em>, however nothing happens when I change the dropdown.</p>
  
  <p>Thanks for your help!</p>