Hello,

I have a VB script that I am using on a workbook that basically hides a row, if the job is completed, by someone typing the word done in that row.
See code below:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

If Target.Value = "done" Then
Rows(Target.Row).RowHeight = 0
Else
End If

End Sub
My problem is, The sheet containing this data (as well as a few additional sheets using the same code), get copied and pasted into one sheet called overview.
I used the paste link option, so that when people work and make changes to a particular sheet, the Overview sheet will display the updated changes.

The problem is the Script to hide a row in the original tab works fine, if someone puts done in that row, but that is NOT reflected in the Overview sheet.
My guess is, because the cell contains =January!B11 (since its using the paste link option). So even though cell B11 in sheet January, contains the value "done" and therefore the row is hidden, the overview sheet still shows it, because it doesn't have the word "done" in the cell.

Is there anyway to get the Overview sheet tab to also hide that row, when the sheet from which that data was pasted from, hides that row?

I hope that makes sense?
any thoughts are greatly appreciated!
babs