Hi, I'm using the following code called from a command button on a sheet called 'Main' to print another sheet called 'Stage 1' in my workbook
"Sheets("Stage 1").PrintOut Copies:=Range("C65").Value"
This works fine as 'Stage 1' is formatted as only one A4 page.
But now I want to print the next worksheet 'Stage 2'. Using a similar code so I get the right number of copies but this one is two A4 sheets long. So I need to open the print dialogue box so that I can select double sided printing. I have tried...
Application.Dialogs(xlDialogPrint).Show
Sheets("Stage 2").PrintOut Copies:=Range("C65").Value
But whilst this does open the dialogue box, it then prints double sided copies of the worksheet 'Main' and then prints Stage 2 using the default settings. How can I send it the print command for Stage 2 but to open the print dialogue for that operation only.
Thanks for any help you can offer.
"Sheets("Stage 1").PrintOut Copies:=Range("C65").Value"
This works fine as 'Stage 1' is formatted as only one A4 page.
But now I want to print the next worksheet 'Stage 2'. Using a similar code so I get the right number of copies but this one is two A4 sheets long. So I need to open the print dialogue box so that I can select double sided printing. I have tried...
Application.Dialogs(xlDialogPrint).Show
Sheets("Stage 2").PrintOut Copies:=Range("C65").Value
But whilst this does open the dialogue box, it then prints double sided copies of the worksheet 'Main' and then prints Stage 2 using the default settings. How can I send it the print command for Stage 2 but to open the print dialogue for that operation only.
Thanks for any help you can offer.