Hiding a single row in a worksheet dependng on a cell change in another worksheet

[bean29]

Hi All,

I am new to the forum and would really appreciate some help with hiding rows. I am aware that there are a lot of posts relating to hiding rows and columns but I am struggling to get any of the responses I have seen to work for what I require.

Basically I have a message box in "sheet 1" row 4, I would like the whole row to hide if the value in "sheet 2" cell H22 has "Yes" present if "" (nothing in it) then the message box in sheet 1 needs to remain visible.

I hope I have provided enough information. oh I am using Excel 2007

Thanks

[p24leclerc]

Hi, here is a workbook with a macro in Sheet2 that does what you want.
You have to create a macro that look at any changes made to Sheet2 and react only if change is made to your specific cell "H22".

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$H$22" Then
  If InStr(1, Target, "yes", vbTextCompare) <> 0 Then
    Sheets("Sheet1").Range("A4").EntireRow.Hidden = True
  Else
    Worksheets("Sheet1").Range("A4").EntireRow.Hidden = False
  End If
End If
End Sub

[bean29]

This works great...thanks so much for your help