Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

printPreview

Status
Not open for further replies.
mn12

mn12

Programmer
Dec 22, 2002
52
IL
Hi All,
I create reports in excel via vb.I have 3 reports,each report on another sheet.I display the reports by "printPreview",but I see only one sheet a time.
My question:
how can I display the 3 sheets one after the other by "printPreview" command?

I try to do that:
Sheets("sheet1").Select
Sheets("sheet2").Select
Sheets("sheet3").Select
Xl.ActiveWorkbook.PrintPreview
but it doesnt work.

your answers would be much appreciated.
 
Sort by date Sort by votes
I think it should look like this ......

Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
Sheets("Sheet1").Activate
ActiveWindow.SelectedSheets.PrintPreview

Good luck,
TopJack
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

jpgactmod
  • Locked
  • Question
PrintPreview freezes and does not let me print
Replies
2
Views
99
jpgactmod
jpgactmod
olympus
  • Locked
  • Question
Excel:Run Code when "close" in PrintPreview is selected
Replies
0
Views
28
olympus
olympus
t16turbo
  • Locked
  • Question
PrintPreview in VBA - not returning to worksheet
Replies
2
Views
42
t16turbo
t16turbo

Part and Inventory Search

Sponsor

Back
Top