Help needed with row hiding based on cell value

[SpectreHUN]

I want to hide certain rows based on a selection from a drop-down list. My code so far:

Private Sub Worksheet_Change(ByVal Target As Range)
If Cells(10, 8).Value = "Yes" Then
  'ActiveSheet.Unprotect
  Rows("11:12").Hidden = False
  'ActiveSheet.Protect , DrawingObjects:=True, Contents:=True, Scenarios:=True
Else
   'ActiveSheet.Unprotect
   Rows("11:12").Hidden = True
   'ActiveSheet.Protect , DrawingObjects:=True, Contents:=True, Scenarios:=True
End If
End Sub

My problem is that the macro runs, it hides said two rows, then when an other item is selected from the drop-down, it doesn't seem to run anymore. Any suggestions? Thanks in advance!

 

[JLGWhiz]

The code says that if H10 value is "Yes" then rows 11 and 12 will be visible. If cell H10 is not "Yes" but is blank or something else then the two rows will not be visible. If changing the selection in the dropdown does not change the value in cell H10, then there will be not change in the status of the two rows. Unless cell H10 holds the drop down and the drop down only has the option of "Yes" or something else, then you won't see a change until cell H10 changes.

 

[SpectreHUN]

Yep, H10 has the drop-down. The options are Yes and No. It works! The problem was that I referenced I10 as (10, 8), whereas it is (10, 9). :D Thanks a lot!

 

[JLGWhiz]

You're welcome,
Regards, JLG