Is there a way to hide rows in other sheet when macro is excecuted in
sheet one?

The macro would have to be expanded to operate on each sheet in turn. You
might create a macros that activates each sheet and then calls this macro.

--
Jim
"Paul_of_Abingdon" wrote in
message ...
|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
|
|