Saving diff print settings for each tab

  • Thread starter Thread starter Daniel
  • Start date Start date
D

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.
 
Daniel,
Is it possible to save different print setting for
different tabs?
Click to expand...
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
 
Back
Top