VBA - Hide/Unhide Blank Rows in a Range & Hide/Unhide Worksheets based on cell comparison

[surecant]

Hello,

I would like to apologize off the top. I'm a newbie when it comes to macros and do not understanding the coding, so bare with me.

I would like to create 2 macros:

#1: Hide/Unhide rows 24:33, 61:72, 102:107, & 115:124 based on if the corresponding "B" cell is blank (hide) or not blank (unhide). This is only on worksheet "Information".

#2. Hide/Unhide worksheets "GL#1, GL#2,...,GL#14" based on their cell "D12" value if >= (hide) worksheet "Information" cell "E44" value, unhide if <= the said cell values.

Hopefully this isn't all that challenging. Please let me know if you need more info.

Cheers!

 

[Stridhan]

Will you run the macro manually or should it run everytime theres an worksheet change?

 

[surecant]

Will you run the macro manually or should it run everytime theres an worksheet change?

I want both macros to run every time there is a change to worksheet "Information" cell "E44".

Also, do i need the same macro for each worksheet, or will the code for worksheet "Information" suffice for all the subsequent sheets...if that makes sense.

Thanks!