VBA code to hide/show rows based on value in each row

Hello KEM4321,

Welcome to the Forum!

I think the last time I visited Kings Mountain, I was a teenager. Beautiful place.

Copy and paste this code in the ThisWorkbook module. This will hide any row when the value of cell in column "H" is zero. This will not hide a row if the value of cell in column "H" is the result of a formula, only if the user changes it manually.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

        If Not Intersect(Target, Columns("H:H")) Is Nothing Then
            If Target.Value = 0 Then Taget.EntireRow.Hidden = True
        End If
        
End Sub