macro 2 print

[abz2max]

i need a macro that will print, but before it doe's it needs to ask the user to confirm it. The area to print will already have been choosen before, so the macro should just print print.

 

[NateO]

Try the following:

Sub printin()
Select Case MsgBox("Are you sure you want to print?", vbYesNo)
Case vbYes
ActiveSheet.PrintOut
Case vbNo
End Select
End Sub