Print specific worksheets in workbook

Good morning

I have a workbook which I would like to be able to print just specified worksheets from. Each month I complete a sales sheet(worksheet) which feeds to the relevant client invoice (worksheet). I want it to be able to just autoprint all those client invoices that have been charged that month and ignore those that haven't (no input data on sales sheet), is there a way of doing this?

Many thanks

Just bumping thread as this forum seems to move so fast unanswered threads get lost in the mists of time

I guess the answer is no you can't then?