Hi
Unfortunately I was not able to perform VBA code correctly (based on onter postings). I'm trying to unhide rows when cell A13 is 1 otherwise rows 15:100 are hidden. The idea behind is basically change some parameters that affect cell A13.
I wrote the code like that:
"
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("A13").Value > 0 Then
Range("15:100").EntireRow.Hidden = True
Else
Range("15:100").EntireRow.Hidden = False
End If
End Sub
"
Thanks in advance for your help.
Unfortunately I was not able to perform VBA code correctly (based on onter postings). I'm trying to unhide rows when cell A13 is 1 otherwise rows 15:100 are hidden. The idea behind is basically change some parameters that affect cell A13.
I wrote the code like that:
"
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("A13").Value > 0 Then
Range("15:100").EntireRow.Hidden = True
Else
Range("15:100").EntireRow.Hidden = False
End If
End Sub
"
Thanks in advance for your help.