Printing some but not all sheets in a workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DRKML - 14 Apr 2005 12:54 GMT

I have a worksheet in which I will print some portion of most - but not
all - of the sheets. Some of those sheets will be printed conditionally. A
couple of sheets would never be printed since they are just tax tables, etc.

The printed document pages would be:
Cover
FAQ
FlowChart
Summary Ledger
Detail Ledger
GiftTax Ledger (Optional)
Collateral Ledger (Optional)
Disclaimers/Legalese

For each area to be printed I'm creating a small macro to print that item.
The four ledgers have a variable length print area based on the person(s)
age. Part of that code is to reset the print area.

As near as I can tell I can't do this in a straightforward fashion in Excel
since I am not printing the complete workbook. My expectation at the moment
is to have to copy the sheets to a temporary workbook, adjust print ranges
as needed, and then print the temporary workbook.

Is there a better way to do this?

Reply to this Message

Paul Cundle - 14 Apr 2005 22:20 GMT

I might be missing something but, once you've set the appropriate print
areas on each sheet using your current macros, is there any reason why you
can't select all of the relevant sheets and then issue a standard print
command using a macro?

You can conditionally select which sheets to print using something akin to
the following:

If [condition] Then Sheets("Sheet1").Select
If [condition] Then Sheets("Sheet2").Select (False)
If [condition] Then Sheets("Sheet3").Select (False)

Using the (false) parameter causes it to add that sheet to the selection
rather than replace the existing selection.

Paul C,

Signature

> I have a worksheet in which I will print some portion of most - but
> not
[quoted text clipped - 22 lines]
>
> Is there a better way to do this?

Reply to this Message

Rate this thread: