Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Printing Multiple Sheets -- Printer Forcing Landscape/Portrait

I'm using Excel 2002 in Windows XP.

I have a large Excel application where users choose to print one or
more sheets. They do this by using the Ctrl key and the mouse to
highlight multiple tabs and then hitting the Print button.

Each worksheet has a defined print area and is set up to fit 1 by X
pages (most are 1 by 1). Each worksheet also has either landscape or
portrait set in the Page Setup, depending on the page layout.

If I choose to print a single sheet that is 1 by 1/Landscape, it prints
fine. If I select this same sheet along with another that is 1 by
3/Portrait. The Landscape sheet will print in Portrait. Sometimes the
Portrait sheet prints in Landscape. I haven't been able to narrow down
why sometimes Portrait wins and sometimes Landscape wins--it doesn't
seem to be affected by which sheet is active.

This only happens on a particular printer: HP LaserJet 8000 Series PCL
6. I'm going to contact our IT department to see if the driver is
updated for that printer.

If anyone has any other ideas what is at issue, I'd appreciate hearing
them.

Thanks,
Jake

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007: Printing both in Landscape and Portrait in one run Abel MacAdam Excel Discussion (Misc queries) 2 August 24th 09 09:31 PM
Printing landscape and portrait Jonno Excel Discussion (Misc queries) 3 July 30th 09 04:45 PM
Printing in Portrait & Landscape Peter D Excel Discussion (Misc queries) 1 August 21st 08 03:14 AM
Printing report that is portrait and landscape jag53 Excel Discussion (Misc queries) 1 February 2nd 08 04:11 AM
Landscape and Portrait Phippsy Setting up and Configuration of Excel 2 January 12th 06 03:21 PM


All times are GMT +1. The time now is 11:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"