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

  • Thread starter Thread starter xz
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find last row with hidden rows 2
Hide row code help 1
Expand and collapse rows 7
My rows keep "unhiding" when I do not want them to 6
Hiding Rows 10
show hide row if 4
showing hidden rows on a protected sheet 10
Cannot unhide the hidden rows in my spreadsheet 3

Back
Top