Hide Rows that a value in a column = 0

[rbac]

I am trying to hide the entire row, if the value in the second column is 0 and unhide it if that changes (it is a formula that is changing the value).

I would like it to automatically do this anytime there is a change in the worksheet, or when that tab of the worksheet is opened/selected.

I have never made a macro in Excel before, I kind of took a few things I found and combined them to make this, but it seems to have no effect at all, maybe it is not being triggered, maybe the code is bad? I do not know.

P.S. I do not know if you have to compile this or how you even attatch it to the worksheet, that may be a start, or if just saving it works? I know a little bit of java, and C+ from forever ago, but nothing of VB.

Thank you for the help!

Please Login or Register  to view this content.

--------------------------------------------------------------------------------

[rbac]

Welp nevermind, my code was messed up, I used this code instead, and assigned it to a button on the worksheet tab and it works great.

Please Login or Register  to view this content.

[arlu1201]

rbac,

Welcome to the forum.

I have added code tags to your posts. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.

Also, I am marking your thread as Solved, since you have solved it. To do so in future - select Thread Tools -> Mark thread as solved.