Hi
I would like to print out 2 pages , the first one is always the same
but the second one depends on the choice you make in the first one
I have 5 "levels" to choose out when you choose one of the "levels"
the matching second page should also be printed out when you click print
( I know it has something to do with page set up print area , but somehow i can' t create the macro to switch between levels and printareas)
the second, tirth, fourth,...pages are beneath the first one (2 blank rows between them)
the levels are "powered on" by a checkbox that gives a true/false value in cell H12 going to L12
e.g. when i click the checkbox for level 2 the cell I12 gives the value True
and then the print area should give the first page +printarea for the second page
PS: when you disactivate all the checkboxes only the first page should be printed
I would like to print out 2 pages , the first one is always the same
but the second one depends on the choice you make in the first one
I have 5 "levels" to choose out when you choose one of the "levels"
the matching second page should also be printed out when you click print
( I know it has something to do with page set up print area , but somehow i can' t create the macro to switch between levels and printareas)
the second, tirth, fourth,...pages are beneath the first one (2 blank rows between them)
the levels are "powered on" by a checkbox that gives a true/false value in cell H12 going to L12
e.g. when i click the checkbox for level 2 the cell I12 gives the value True
and then the print area should give the first page +printarea for the second page
PS: when you disactivate all the checkboxes only the first page should be printed
