macro 2 print

abz2max · May 3rd, 2002, 03:18 PM

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 · May 3rd, 2002, 03:43 PM

Try the following:

Code:

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

May 3rd, 2002, 03:43 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Try the following: Code: Sub printin() Select Case MsgBox("Are you sure you want to print?", vbYesNo) Case vbYes ActiveSheet.PrintOut Case vbNo End Select End Sub __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 3rd, 2002, 03:18 PM	#1
abz2max New Member Join Date: Apr 2002 Posts: 19	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.