set print area based on selection

C

crombes

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
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print Area Range Selection 2
Print Setup Not Set 1
MULTIPLE PRINT AREA 3
Dynamic Print Area 2
Set print area based on last row with a given value 3
Split Print Area: How to make it print to one page 3
Print Ranges 7
Macro to set variable print area 0

Top