Right-click the sheet tab, select View Code, enter this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 4 Then
If LCase(Target.Value) = "yes" Then
Target.EntireRow.Hidden = True
End If
End If
End Sub


"Graham" wrote in message
...
please advise if it is possible to hide a row if data is entered in a
specific cell within that row.As an example if I enter the text "Yes" in
cell
D2, then row 2 must then be hidden !! Just a thought as I am creating a
spreadsheet to track items and once I have actioned a certain task I then
want to auto hide that item.

Thanx Graham