Different Print Setup Same Page

[Karl Burrows]

Is there a way to setup a worksheet to print one range 2 pages wide, legal
and another just one page wide letter if they are on the same worksheet tab?
I've tried custom views and report manager, but they default to whatever is
setup in page setup? I tried setting the print area, but again am limited
to the page setup to determine print size.

Thanks!

 

[Frank Kabel]

Hi Karl
this could only be done with VBA. You may try the following:
- start recording a macro
- setup the page for your first sheet
- print only the first page
- change the setup
- print the other page
stop the recording

 

[Karl Burrows]

Worked great! I recorded the Macros to print 3 different areas with
different setups, etc. I had to tweak the code a bit to get everything to
print the way I wanted, but all-in-all, it worked great! I created a
toolbar with the print Macro on it to make it easy to run the print.

How can I now combine that with printing on another page? The activesheet
command won't work if I'm not in that sheet. Also, if I were to copy the
tabs to create duplicates for a new project, how can I carry the Macro over
to print the same areas on those 2 worksheets?

Thanks!

 

[Frank Kabel]

Hi
for printing a differen sheet you may use something like the following:

dim wks as worksheet
set wks = worksheets("other sheet")
wks.printout