printpreview

Hello, I'm trying to add a macro on a sheet to print preview the page, after hiding blank lines. Id like the end result to be a print preview on 2 pages - 1st to cover A1:C449 and the second to show A450:C620 The below code works but it shows my data over 4 pages rather than 2 - is it...

Hi everyone, I was wondering if someone could help me with the following. This code shows the print preview, but always starts from the first page: Sub PrintPreview() ActiveSheet.PrintPreview End Sub This one shows the selected cells only: Sub PrintPreview() Selection.PrintPreview...

I am creating a new Workbook using VBA from another Excel Workbook. I then want to perform a PrintPreviewof the new Workbook. However, the whole thing hangs. I believe this is because the PrintPreview is executed before Excel has completed creating the new Workbook. I have looked and looked and...

Hey All, Been trying to troubleshoot this issue for a user in my office. End user is using Excel 2003. She has a spreadsheet that has multiple sections and text formatted in color. When she chooses Print Preview, all the colored sections show up as Grey. When the document is printed, it...

Hi, I have code in my Workbook_BeforePrint routine, but I don't want it to be executed if the event is triggered by the PrintPreview, so I can I know if the event has been raised by the PrintPreview button instead of the Print button? Thank you

Hi I am using following code for print preview of spreadsheet. 'command button to print site survey water worksheet Private Sub cmdPrintSiteSurveyWater_Click() On Error GoTo ErrorLine Dim SiteSurveyWater As Integer ' message box to prompt print out SiteSurveyWater = MsgBox("Do you want to take...

Setting the Cancel arg in the BeforePrint event to TRUE also prevents using the PrintPreview command. Has a workround this been addressed before? Regards.