The line that actually does the printing is:
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:=tprinter,
Collate:=True, _ IgnorePrintAreas:=False
comment it out and you should be good to go!
Paul-
“Do all the good you can,
By all the
That looked really good for a bit but the macro also saved a version to a
folder which commenting this out has stopped. Is there any way of isolating
just the print function? Thanks so much for the help it is hugely
appreciated
On Wednesday, May 25, 2016 at 12:31:14 PM UTC+1, Paul Schreiner wro
The tPrint function is what does the actual printing.you could simply comment
out the line that calls this function:
' ** added section end **ttdate1 = Mid(ttdate, 4, 2) + "/" +
Left(ttdate, 2) + "/" + Right(ttdate, 2)'TPrint ttref, ttroute, tprinter,
tecode Paul
