how 2 hide row if row in another sheet is hidden?

X

xz

Hi to all!

I want to hide row #3 say, in worksheet 'a', if row #4 in worksheet
'b' is also hidden. And if its not hidden, I want the row in worksheet
'a' also to remain unhidden.

Not sure how to do this.... Thanks!

Jason Shohet
 
H

Harj

Hi,

A simple code on selction change or sheet activate event would do the trick:-
Sheets("b").Rows(lIndex & ":" & lIndex).Hidden = Sheets("a").Rows(lIndex &
":" & lIndex).Hidden

Above code will change sheet b rows to match sheet a. You will nd to
impliment loop to go through all rows in sheet a.

regards
 
Top