X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Stuck in Print Preview, Office 2007    
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

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?
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: 21st December 2014 - 07:03 AM