UtterAccess.com
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: 30th July 2014 - 06:06 AM