Print Yes Or No

[delta]

in Invoice sheet i create a button like "ADD DATA" when i click on button the data will be copy in sheet 2 and then ask me print invoice "YES" OR "NO" in sheet "Invoice Sheet" when yes then print invoice and no then do not print invoice with vba macro only.
and i do not create a another button do this only "ADD DATA" BUTTON.

 

[Monty]

Try this

Sub Test()

If Vbyes= True Then

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End If
End Sub