I have seen many posts about hiding rows based on a value, but my case is
slightly different. I need to hide a row (or rows) in one sheet based on
values entered on a separate sheet -- both sheets are part of the same
workbook though.

A quick rundown of what I am up against..... I have a workbook containing
two sheets, one sheet we'll call Order and the other is Invoice. On the
Order sheet, we have two columns, one for the product names and another for
the quantity desired of each. The Invoice sheet will have the same list of
products and the quantity desired, however, it also will have the price per
each, and total for each based on desired quantity, and finally a totaled
overall price at the bottom.

The way I am trying to get this to work is that when a quantity number is
typed on the Order sheet, that number appears on the Invoice sheet for the
matching product, the Invoice sheet then totals the price for that product,
and the overall total is computed. This is straightforward excel stuff, but
my problem is how to hide the rows of those products that have a 0 quantity?

I have tried using the "Worksheet_Change" method on the Invoice sheet:

Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next

If Target = Range("A2:A10") Then ' A2-A10 : product quantity cells
whose values are changed from the Order sheet
If Len(Target.Value) 0 Then
If IsNumeric(Target.Value) Then
If CInt(Target.Value) = 0 Then
Rows(Target.Row).RowHeight = 0
Else
Rows(Target.Row).RowHeight = 15
End If
End If
End If
End If

End Sub

But the above does not fire unless I manually click on and change the cells
on that sheet -- setting the Invoice cell to equal a value from a cell on
Order and changing the value from Order does not fire the event. I think it
may be because the cell's value is set to something like "=Invoice!E6"
instead of "0", but if that's the case, how do I get to the value being
passed in?

Any help is greatly appreciated.

-- Andrew