You may want to check out the View | Custom Views Feature. It should be able
to remember different Print Options for different Custom Views. It worked
fine for the quick test I just did.
You may be able to mimic having two print areas using this feature.
tj
"Willis" wrote:
I've got a worksheet that has two columns for each month going out
three years some subtotals at the far right. Depending on who the
audience is, I need to print 12 months to a page (landscpae 3-pages) or
do a single page summary (portrate one page). Is there a way that I can
save my page layout and quickly switch between the two? I can't put the
summary data on a seperate tab (per my bosses request). I want to find
a way to save the page layout and print options and toggle between the
two.
|