UtterAccess.com
We have detected that you are using an unsupported web browser. We recommend you to upgrade your web browser to get the most from UtterAccess forums.
Why should and how can I upgrade?
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Stuck in Print Preview, Office 2007    
 
   
JohanF
post Jun 12 2010, 03:10 PM
Post #1

UtterAccess Enthusiast
Posts: 81
From: South Afrika



Hi guys!
I used the following code to print a stock report:
LROW = Worksheets("Stock").Cells(Rows.Count, "B").End(xlUp).Row

Dim REPORT As String
REPORT = "A1:G" & LROW

With Worksheets("Stock")
'Print preview
.PageSetup.PrintArea = REPORT
.PageSetup.Draft = True
.PageSetup.PaperSize = xlPaperA4
.PageSetup.FitToPagesWide = 1
.PageSetup.FitToPagesTall = 2
.PrintOut Copies:=1, Preview:=True
End With
It worked well in Office 2003, but in 2007 the buttons in the print preview are all greyed out - I cannot view the second page nor can I print or close the preview. Can only get out there by clicking the [X] Colse at the right top.
Any suggestions?
Thanks!
Go to the top of the page
 
+

Posts in this topic


Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 25th October 2014 - 05:47 PM