I am creating a macro enabled workbook with multiple named worksheets (eg, Input, H/W, Calcs, Quote, etc). I want to use the following to hide/unhide rows on 1 specific worksheet only. But so far its not working
Specifically I want to hide rows 7&8 on my "HW" worksheet when cell F5 (which is list validated cell, aka dropdown), changes from "Yes" to "No"
Private Sub Worksheet_Change (ByVal Target As Range)
If Range("E5").Value= "Yes" Then
Rows("7:8").EntireRow.Hidden= True
ElseI ifRange("E5").Value = "No" Then
Rows("7:8").EntireRow.Hidden= False
End If
End Sub
Specifically I want to hide rows 7&8 on my "HW" worksheet when cell F5 (which is list validated cell, aka dropdown), changes from "Yes" to "No"
Private Sub Worksheet_Change (ByVal Target As Range)
If Range("E5").Value= "Yes" Then
Rows("7:8").EntireRow.Hidden= True
ElseI ifRange("E5").Value = "No" Then
Rows("7:8").EntireRow.Hidden= False
End If
End Sub