not quite.

i selected the printer, but when the code reached the 11"x17" paper setting
there was an error message. your suggested code seems like it does not set
it as the default printer.

initially i was using:

Application.ActivePrinter = "\\JBXSl05\JBX_LD160C_R1880 on Ne04:"

With Sheets("ProjIdRollUp").PageSetup
.PrintTitleRows = "$1:$5"
.LeftFooter = "&8&Z&F&A"
.CenterFooter = "&8&D"
.RightFooter = "&8&P of &N"
.CenterHorizontally = True
.Orientation = xlLandscape
.PaperSize = xlPaper11x17
.PaperSize = xlPaperTabloid
.Order = xlOverThenDown
.Zoom = 69
End With

which worked, but that was when i thought only my guy was going to use it
here but it is going to be sent to others. and when it gets to the
'PaperSize' i get an error message.

--
Message posted via http://www.officekb.com