VBA to hide rows

[Russk68]

Hi All,

I want to hide a row when the value in column A=0. If there needs to be a limit then it would be A1:A1000 with any number of rows that can be hidden.
I would also like the code to run only when the sheet is opened.

Thank you!

Russ

 

[Russk68]

Hi James
Should this code run automatically when I open the sheet?

 

[Fluff]

Hot dog!
Coolest 3 lines of code I ever saw!

Thank you Fluff!

You're welcome & thanks for the feedback

 

[Russk68]

Cool!
That works great! I just changed it to Activate.
These options are awesome!

Thank you!

 

[James006]

You are welcome ...