I have written a macro to hide rows if the value in a row is false. I put
this macro in "ThisWorkbook" code window, instead of a worksheet window. The
Macro starts after an user makes a selction from drop down Control box in
worksheet ONE. This macro works fine. I have 50 more sheets with same row
information. I would like to hide those rows as well when the macro is
executed. Other sheet does not have drop down control box. When True or false
value changes in rows of sheet one after user's selection, the value in other
sheets also changes because I have used PASTE LINK in other sheets. Is there
a way to hide rows in other sheet when macro is excecuted in sheet one? Here
is my Macro to hide rows with control box:

Sub HURows()
BeginRow = 9
EndRow = 211
ChkCol = 8

For RowCnt = BeginRow To EndRow
If Cells(RowCnt, ChkCol).Value = "False" Then
Cells(RowCnt, ChkCol).EntireRow.Hidden = True
Else
Cells(RowCnt, ChkCol).EntireRow.Hidden = False
End If
Next RowCnt
End Sub

Private Sub ComboBox1_Change()

End Sub