ExcelBanter - .PrintPreview ONLY Page 1

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - .PrintPreview ONLY Page 1 (https://www.excelbanter.com/excel-programming/381029-printpreview-only-page-1-a.html)

Corey

.PrintPreview ONLY Page 1

ActiveWindow.SelectedSheets.PrintPreview

Is there a way i can ONLY View Page 1 with the code above ?

JE McGimpsey

.PrintPreview ONLY Page 1

One way:

ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1, Preview:=True

In article ,
"Corey" wrote:

ActiveWindow.SelectedSheets.PrintPreview

Is there a way i can ONLY View Page 1 with the code above ?

All times are GMT +1. The time now is 01:23 AM.