print button on work sheet

[griff888]

I have recently produced an invoice and want to add a print button to the work sheet this button would take me straight to print options as I want to print 1 copy for the customer in normal print and 2 copies for the business in fast print
1st question is there a way of creating print in the 2 different print modes so that I need to only one click the button if so what code would I use for the command button
2nd question if the above is not possible what code would I use to bring up the print option box.
I need to hide the tool bars etc so that staff arent tempted to alter any of the options available when producing the invoice.
hope someone can help cheers

 

[VoG]

Try like this

Private Sub CommandButton1_Click()
Application.Dialogs(xlDialogPrint).Show
End Sub

 

[griff888]

thanks again vog twice in two days you have been able to give me quick answers to my questions you are a great help