I'm not sure how or what your wanting to hide but maybe this will get you
started.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Cells(1, 1) < "" Then
ActiveCell.EntireRow.Hidden = True
End If
End Sub
What the above code will do is if cell A1 is not blank then for each cell
you click on it will hide the row.
HTH
"Andrew Appel" wrote in message
...
How can I hide rows in Excel, using VBA, upon an event, like a click in a
control?
THANKS!
andrew