Using a Checkbox to Hide Rows based on Cell Value

Hi all

I've got a spreadsheet that I'm using a checkbox to hide rows based on whether the checkbox is checked or not. I've got it to work if I specify which rows the condition relates to.

However, I'd like to turn it up a notch, and specify the whole sheet as a range, and hide all rows which contain a predetermined text value in a specified column.

Here's the current code:

Please Login or Register  to view this content.

This works fine, but relies on a specified range. I've tried lots of ways of doing this the alternative way, but can't achieve what I want

Essentially, when checkbox 1 is checked, I want all rows which contain "string" in column K to be hidden.

Any help would be much appreciated!!