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

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Stuck in Print Preview, Office 2007    
post Jun 12 2010, 03:10 PM

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

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

Custom Search
RSSSearch   Top   Lo-Fi    10th October 2015 - 05:50 AM