VBA Code:
Sub Button561_Click()
' Enter_Date_and_Print()
Dim MyDate As Date
MyDate = Application.InputBox("Please Enter a Date", "Date")
Range("C3") = MyDate
' Change Copies:=2 (below) to 1 or however many copies you want
ActiveWindow.SelectedSheets.PrintOut Copies:=2
End Sub
If the user clicks Cancel instead of entering a date it still prints. What can I add to this statement to cancel the print job if they click Cancel instead of OK?
Also, is there a way to get a prompt for which Printer to use?