When printing several different sheets from the same Excel file, there will be several jobs in the printing queue, especially if the printer is offline. I sometimes wish to delete some of those jobs that may have been accidentally printed. Unfortunately the all have the same name – the Excel filename – in the queue making it difficult to find the one(s) to be deleted.

Is there a way in VBA to set the filename of the printed document, perhaps to use the sheet name rather than the filename? (I use macros to print most reports and want to add this extra option.)