If Range1 Not Hidden on Sheet1 Then Show Range2 on Sheet2

Hi. I was hoping for a little help coding this.

I'm using this to hide and show ranges on my sheet1

Please Login or Register  to view this content.

I want an onchange even i think its called.

That as soon as "Blood" range which is on sheet 1 is hidden=false (visible) THEN

a range on sheet2 i have designated Blood_Show will automatically become unhidden

as soon as that range blood is hidden again then Blood_Show would again dissapear/behidden on sheet 2


Any help with this would be really appreciated! Thanks so much!

Here's an example of what i'm trying to do but it is not working. changed sheet names....

Please Login or Register  to view this content.

any idea why it is not working? i want it to automatically change on home page when its changed on district page