Need Help. VBA hide row based on pull down

[kbotta]

Hi Y'all. Hope i am in the right spot for some VBA help. Novice here.
I have an action item/ gantt chart spread sheet. I would like the entire row to hide via a pull down for is the item complete status (yes/ no pull down). I have code that will hide 1 row, and a button to "show all hidden rows" that finction. I need the code to work for more than 1 row - i need it to work whenever the status is changed to complete.
Here is what I have so far:

"Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, Range("o6:o6")) Is Nothing Then
        If Range("O6").value = "Yes" Then
            Rows("6:6").Hidden = True
        Else
            Rows("6:6").Hidden = False
        End If
    End If
End Sub" 

Also - column "O" is where the pull down is...
Thanks in advance for your help - and sorry if i didnt post the script correct..
Kevin