Right click sheet tabview codeinsert this
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < Range("e2").Address Then Exit Sub
If LCase(Target) = "yes" Then
Rows(10).Hidden = True
Else
Rows(10).Hidden = False
End If
End Sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeremy" wrote in message
...
I have it working but you have to play the macro. How would you get the
macro to auto play?



"Jacob Skaria" wrote:

Sub Mac()
Rows(10).Hidden = IIf(Range("E2") = "Yes", True, False)
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Jeremy" wrote:

I have recorded a macro to hid row 10. How would I automate this macro
to
hide if E2 has yes and unhide if it has no?


Thank you

Jeremy