Print
 

Would like to create a command button, so when I click it
it prints
Sheet 3
Sheet 2
Sheet 1 pages 2 and 5

What would my Statement look like?

If I could be really spoiled I would like it to also to
open the File save dialog box, in the correct folder
Thank you

Susan

Print
 

Susan

you could record a macro while you carry out the required printing. You'll
get something like the following:

Sheets("Sheet3").Select
ActiveWindow.SelectedSheets.PrintPreview
Sheets("Sheet2").Select
ActiveWindow.SelectedSheets.PrintPreview
Sheets("Sheet1").Select
ActiveWindow.SelectedSheets.PrintOut From:=2, To:=2, Copies:=1, Preview
_
:=True, Collate:=True
ActiveWindow.SelectedSheets.PrintOut From:=5, To:=5, Copies:=1, Preview
_
:=True, Collate:=True

I've used PrintPreview to save on the paper. You should get PrintOut
throughout and/or Preview:=False

Regards

Trevor
"Susan" wrote in message
...
Would like to create a command button, so when I click it
it prints
Sheet 3
Sheet 2
Sheet 1 pages 2 and 5

What would my Statement look like?

If I could be really spoiled I would like it to also to
open the File save dialog box, in the correct folder
Thank you

Susan