Automate printing of multiple sheets in Excel

I once received this request from a Finance Manager. He had this Excel file with close to 10 worksheets and he only needed to print 6 of the worksheets every month during the management meetings. He needed to print ALL the 6 sheets without having to do it one at a time. This sounded simple, but when I looked at the options for printing in Excel it was not going to be possible.

I therefore developed a macro that would print each of the 6 worksheets in sequence. This I later modified to print a list of selected worksheets based on the users preferences.