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.
Bookmarks