Without your relevant code, it's a complete guess, but do you something like
this
Private Sub Workbook_BeforePrint(Cancel As Boolean)
ThisWorkbook.PrintOut
'Without this line of code
'Cancel = True
End Sub
NickHK
"iKKi" <(E-Mail Removed)> wrote in message
news:el1nik$c05$(E-Mail Removed)...
> Chek your default printer settings!?
>
> "Mark J" <(E-Mail Removed)> wrote in message
> news:F6905243-07D1-43E1-A186-(E-Mail Removed)...
> > After code has run in workbook, workbook is being sent to printer
> > countless
> > times even though in code it is told to print out only once. any ideas?
>
>
|