print macro

[mohamed ali abdelgawad]

hi all
I'am beginner in VBA
and want to ask two questions

1
i have this code to print my sheet

Sub prrint()
Application.Dialogs(xlDialogPrinterSetup).show
ActiveSheet.PrintOut , Copies:=2
End Sub

first line ask me witch printer i will print in
the second one print two copies
my print aria is two pages

1. but wen i use this code it print 3 pages but the third is blank
2. also i can't find how to set it to print front and back.

2
after all that i have another macro to save and send mail and close sheet
what i need to do is adding the above print code to it

• but i want to add option when run macro to ask if i want to print or not.

thanks

 

[mohamed ali abdelgawad]

help me please