Print "Dynamic" Sheets if cell =

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.

try something like this

Please Login or Register  to view this content.

Thanks M8, works a treat. But it doesn't work when them few sheets are hidden. All good though , I just wont hide them.

Cheers