Tech Academy 2009

how to assign a macro to an option button in excel

http://support.microsoft.com/kb/141689

  Thanks,Bob

Hiding Excel Rows when Columns are Null or Zero

Add the following macros and set the range as needed. 

Sub HideZeroRows()
Dim r As Range, cell As Range
Set r = Range(”C7:C8̸
For Each cell In r
If cell = 0 And cell.Offset(0, 1) = 0 And _
   cell.Offset(0, 2) = 0 Then
    cell.EntireRow.Hidden = True
Else
    cell.EntireRow.Hidden = False
End If
Next
End Sub

Sub UnHiderows()
Rows.Hidden = False
End Sub

Taken From
http://en.allexperts.com/q/Excel-1059/2009/5/Hiding-Rows-Zero-Values-1.htm