ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Continual printing? (https://www.excelbanter.com/excel-programming/378708-continual-printing.html)

Mark J

Continual printing?
 
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?

iKKi

Continual printing?
 
Chek your default printer settings!?

"Mark J" wrote in message
...
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?




NickHK

Continual printing?
 
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" wrote in message
...
Chek your default printer settings!?

"Mark J" wrote in message
...
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?







All times are GMT +1. The time now is 09:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com