Hi johnnycanuck, the following code will hide rows with a 0 in them 
Sub RowHider()
    Dim wb As Workbook
    Dim shtCnt As Long, shtCntr As Long
    Dim StrtRng As Variant, EndRng As Variant, FullRng As Variant, cl As Variant
    Set wb = ActiveWorkbook
    shtCnt = wb.Sheets.Count
    For shtCntr = 1 To shtCnt
        With wb.Sheets(shtCntr)
            Set StrtRng = .Range("F2")
            Set EndRng = .Range("F10000").End(xlUp)
            Set FullRng = Range(StrtRng, EndRng)
            For Each cl In FullRng
                If cl.Value = 0 Then
                    cl.EntireRow.Hidden = True
                End If
            Next cl
        End With
    Next shtCntr
End Sub
As for your other requirements, it seems like a lot of dialog pop-ups, or can be a lot, for the user to decide on. At any rate, that will require a form with options on it, which may take a little while to design, at least for me it will. However, I can do it but I cannot promise you'll get it post-haste!