VBA CODE TO HIDE ENTIRE ROW WHEN YES IS SELECTED IN DROP DOWN MENU AND UNHIDE WHEN NO IS SELECTED

[Craig_Moore]

Hi All

i'm trying to use the code below to hide row 15 when DAY LIGHT SAVING is selected in a drop down menu in dls (d4) and unhide when YES is selected in the drop down menu

currently the code is hiding the row but when i change the selection it is not unhiding the row

any help would be greatly received

thanks

craig

Private Sub Worksheet_Change(ByVal Target As Range)

ActiveSheet.Activate
If Not Application.Intersect(Range("dls"), Range(Target.Address)) Is Nothing Then
Select Case Target.Value
Case Is = "DAY LIGHT SAVING": Rows("15:15").EntireRow.Hidden = True

Case Is = "YES": Rows("15:15").EntireRow.Hidden = True
                
End Select
End If

End Sub

 

[davesexcel]

You have both results as true, one of them need to be false

 

[Craig_Moore]

You have both results as true, one of them need to be false

thanks that was an daft mistake to make

thanks again

craig