My VB script, doesn't work when I take that same data and use paste Link to another sheet

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:

Please Login or Register  to view this content.

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

Something along the lines of:

Please Login or Register  to view this content.

Hello yudlugar,
That did it!!!
Thank you so much!!!
babs