Hi Y'all. Hope i am in the right spot for some VBA help. Novice here.
I have an action item/ gantt chart spread sheet. I would like the entire row to hide via a pull down for is the item complete status (yes/ no pull down). I have code that will hide 1 row, and a button to "show all hidden rows" that finction. I need the code to work for more than 1 row - i need it to work whenever the status is changed to complete.
Here is what I have so far:
Also - column "O" is where the pull down is...PHP Code:
"Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("o6:o6")) Is Nothing Then
If Range("O6").value = "Yes" Then
Rows("6:6").Hidden = True
Rows("6:6").Hidden = False
Thanks in advance for your help - and sorry if i didnt post the script correct..