Ah if its in a combo box it wont trigger the worksheet_change event.
it needs to be in a module sub triggered by the dropdown box.
Sub DropDown1_Change()
    If Range("I4").Value = "HIDE" Then
        Rows("33:41").EntireRow.Hidden = True
    ElseIf Range("I4").Value = "UNHIDE" Then
        Rows("33:41").EntireRow.Hidden = False
    End If
End Sub