set print area based on selection
 

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 clic
print
( I know it has something to do with page set up print area , bu
somehow i can' t create the macro to switch between levels an
printareas)
the second, tirth, fourth,...pages are beneath the first one

the levels are "powered on" by a checkbox that gives a true/false valu
in cell H12 going to L12
e.g. when i click the checkbox for level 2 the cell I12 gives the valu
True
and then the print area should give the first page +printarea for th
second page

PS: when you disactivate all the checkboxes only the first page shoul
be printe

+-------------------------------------------------------------------
|Filename: W DO 01 19_ppap checklist.zip
|Download: http://www.excelforum.com/attachment.php?postid=3984
+-------------------------------------------------------------------

--
crombe
-----------------------------------------------------------------------
crombes's Profile: http://www.excelforum.com/member.php...fo&userid=1712
View this thread: http://www.excelforum.com/showthread.php?threadid=48101