Conditioned printing macro issue

Hey Brand new to excel but I have been using it in the workplace and find my self to be learning fast.

I need a conditioned printing macro to print certain sheets and not others based on a value of a cell per sheet

here is the macro i am using which makes the "control sheet"

Please Login or Register  to view this content.

Now here is the other macro which reads this sheet and prints based on if there is ANY value in the B cells

Please Login or Register  to view this content.

My issue is that I would like it to print the sheets if the cell value reads "yes" or maybe if the value is greater than 0.
Ive tried =If but it still counts as filling in the cell.

Please edit your post and add code tags.


AA CodeTags.jpg