set print area based on selection

crombes

New Member
Joined
Mar 17, 2005
Messages
17
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
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Forum statistics

Threads
1,213,492
Messages
6,113,967
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top