CheckBox coding to work with ComboBox coding

I've got a good start to a file (with lots of help from you all!) where I can sort and filter raw data based on the criteria I choose. If you look at the attached file, I'm trying to make it work so that I can go through steps 1, 2 and 3.

Example1.xlsm

Unfortunately, I'm stuck with the checkbox on step 2. If I choose to exclude the closed projects, and then filter with step 3, it will include the closed projects again. Can anybody help me figure out what I'm missing?

Thanks for any help!

Anybody? I know it has something to do with dependency on the checkbox control. I've tried adding some if lines into the ComboBox coding regarding the CheckBox but I'm just not doing it right because then it only shows closed projects

Would something like this in the ComboBox code take into account the checkbox??

If  .Range("R" & r).Value = CheckBox1.Value = True