Use Macros to hide Row

[bhawana]

If you cud help me fix the Following problem..

I want that if the value of Cell Z2 is 1 show row 2, if the value is 0 hide row 2.
I want to do this for Cells Z2 to Z130.
I want to apply this to only one sheet of my workbook.
And the value in Cells Z2 to Z130 is linked from the value in another sheet of my workbook.
Also I wud luv it if the formula works automatically without me having to initiate or run the macro.

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Calculate()
Dim i As Long
For i = 2 To 130
    Rows(i).Hidden = Range("Z" & i).Value = 0
Next i
End Sub