I have a workbook with 20 worksheets.
I need to print these sheets out in one go and have created a macro to do so. The problem I have is that some of the sheets have images in, and these take longer to print than the plain text sheets, the end result being that some of the sheets are printed out of sequence.
I think I need to be able to "pause" the printing to give the sheets with the images in time to print.
I am printing over a network, not to a local printer. When I print to a local printer the print out is fine.
Any ideas how I may pause the printing ?
I need to print these sheets out in one go and have created a macro to do so. The problem I have is that some of the sheets have images in, and these take longer to print than the plain text sheets, the end result being that some of the sheets are printed out of sequence.
I think I need to be able to "pause" the printing to give the sheets with the images in time to print.
I am printing over a network, not to a local printer. When I print to a local printer the print out is fine.
Any ideas how I may pause the printing ?