Hi all, What I'm trying to do is print sheets when certain info is displayed in a certain cell in that sheet when I hit the print button.

for example

There are 3 sheets all up

Cell A1 on sheet "test1" = True then - I want it to print that sheet only

but if

Cell A1 on sheets "test1" and "test3" = true - Then I want it to print them two sheets, but not sheet "test2" as cell A1 will be false.

or

sheet "test1" "test2" "test3" in cell A1 will be true - Then it will print all 3 sheets.

All these sheets will be hidden to btw.

Thanks in advance

Damo.