Hide/Unhide Rows based on Zero Value

Hi

I think the code below may help you in hiding rows with zero value in column B and un-hiding the rows where the value is no longer zero.

Sub HideRowsWithZero()
    Dim x  As Integer
    Dim CheckValue
    x = 1
    Range("A1").Activate
    Do Until x > ActiveSheet.UsedRange.Rows.Count
        CheckValue = ActiveCell.Offset(0, 1).Value
        If CheckValue = 0 Then
            ActiveCell.EntireRow.Hidden = True
        ElseIf CheckValue <> 0 And ActiveCell.EntireRow.Hidden = True Then
            ActiveCell.EntireRow.Hidden = False
        End If
        ActiveCell.Offset(1, 0).Activate
        x = x + 1
    Loop
    Range("A1").Activate
End Sub

This will use Auto-Filter to hide/unhide rows based on changes in values in cells B8:B10 per your sample workbook.
It is much more efficient than looping.

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

    If Target.Cells.Count > 1 Then Exit Sub

    Application.ScreenUpdating = False
    If Not Intersect(Target, Range("B8:B10")) Is Nothing Then
        With Sheet1
            .AutoFilterMode = False
            .Range("B1").CurrentRegion.Offset(, 1).Resize(, 1).AutoFilter Field:=1, Criteria1:="<>0", Operator:=xlAnd, visibledropdown:=False
        End With
    End If
    Application.ScreenUpdating = True
    
End Sub

Palmetto, thanks for the code, however when I try and use it, it brings up a macros box, asking which macro to use... what am I doing wrong?

The code I gave is based on your sample workbook and is designed to go into the sheet module and execute when a cell, in the range of B8:B9, changes value. It was not intended to be assigned to a button.

To get a precise solution from the start, you should always post a sample workbook that EXACTLY duplicates the structure of your real workbook. In order to avoid more questions, please upload per the aforementioned.