Hiding rows with a macro

[herpasymplex10]

I've seen other codes here but can't seem to make them work for my specific need.

I would like a macro (or any option really)
that will hide all rows.

I guess the 'catch' is this:

I want this macro to hide the row if all numbers in the row are above 0

(leaving all rows that have numbers below zero)

My sheet has 8 columns - 3 of those columns have the numbers in it
if any of those columns have a number less than zero, the whole row will stay visible
(even if the other two columns have numbers that are above 0)

Help?

 

[texasalynn]

here is a sample of a worksheet change code, that should be easily modified to work with what you are wanting

Private Sub Worksheet_Change(ByVal Target As Range)
 If Target.Column = 2 Or Target.Column = 3 Then
  LastRow = Range("A" & Rows.Count).End(xlUp).Row
  Sheets(2).Rows.Hidden = True
   For Goods = 1 To LastRow
    If Cells(Goods, 2) > 0 Or Cells(Goods, 3) > 0 Then _
     Sheets(2).Rows(Goods).Hidden = False
   Next
 End If
End Sub

</PRE>