the solution works but doesn't make sense.
you have to close the excel file and application then reopen it to print
another worksheet
this will stop the adobe pdf driver from prompting for filename when
printing more than one worksheet.