Hide All Rows with 0 Each time a Data Validation is Changed

Good afternoon all,

I've got a document with a handful of data validations that hide/show X rows depending on what is chosen via the data validation, and I'm looking for some code that will hide all rows that have a value of 0 when the row is unhidden via value selected in data validation. Below is some code that works wonderfully for the purpose of hiding the 0s when data validation is selected; the only issue Im having with it is anytime I change ANY cell, it runs (and takes a few moments to complete, which is annoying). Ultimately what I'm looking for is an alternate to the below code that does what the below code does, but only when a data validation is the value that is changing.

Please Login or Register  to view this content.

At the top, before you do anything else, check to see if the changed cell had validation in it.

Please Login or Register  to view this content.