UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

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



Posts: 81
Joined: 4-April 05
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



RSSSearch   Top   Lo-Fi    19th April 2015 - 05:56 AM