Saving diff print settings for each tab

[Daniel]

Is it possible to save different print setting for
different tabs? for example, Sheet 1 is to be printed on
a HP Lazerjet (default printer), 8.5x11 but Sheet 2 goes
to a HP500 which prints very large poster-size jobs.
Every time I save then re-open my documents the HP500
sheet has to be reformatted.

 

[John Wilson]

Daniel,

Is it possible to save different print setting for
different tabs?

Not that I know of.

One option that you might try.....
Record a macro to print the first sheet on a selected printer.
Then record a second macro to print the second sheet on
the other printer.

In the Workbook.Before Print again, test to see which sheet
is active at the time and call the appropriate macro.

If Activesheet.Name = "Sheet1" Then
' print via macro1
End If
If Activesheet.Name = "Sheet2" Then
' print via macro2
End If

John