I have a macro which print previews a number of filtered lists in succession, with the user selecting either Print (to print the previewed list) or Close to preview the next list in between each application of filtering and PrintPreview.
I was hoping to include a counter to report (via a MessageBox at the end of the routine) the number of lists (ie. print jobs - NOT pages) actually printed so that the user knows how many reports they should expect to find on the printer.
I have put a counter in the Workbook_BeforePrint event, but it counts a PrintPreview as a valid event!
Is there any way of counting only those jobs printed and ignoring those jobs only Print Previewed?
I was hoping to include a counter to report (via a MessageBox at the end of the routine) the number of lists (ie. print jobs - NOT pages) actually printed so that the user knows how many reports they should expect to find on the printer.
I have put a counter in the Workbook_BeforePrint event, but it counts a PrintPreview as a valid event!
Is there any way of counting only those jobs printed and ignoring those jobs only Print Previewed?