Two different print previews on two differnt operating systems.

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Hello all. Hoping someone can help me here.

Has anyone ever ran across a situation where when the user
clicks print preview in Excel, on one operating system
(Windows NT) you get 2 pages, but when on another
operating system (Windows 2000 or XP) it comes in as one
page? The same situation occurs when the user prints.

If so, how did you solve this problem?
 
Hi Eric

Always a problem with different printers
If you print with code you can try this

Sub test()
With ActiveSheet.PageSetup
.FitToPagesWide = 1
.FitToPagesTall = 1
End With
ActiveSheet.PrintOut
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print Preview Discrepancy 10
Arggh! Each row prints on separate page 2
Excel cuts off bottom of page in Print Preview 2
Shared Excel Workbooks Show different layouts between users 1
Can not print in Color 14
print preview trouble 1
2007 Print Preview Changes Zoom 1
Dotted Linestyle is not seen in Print of the excel 1

Back
Top