[BarTopDancer]

I have a multi-page workbook that I created macros to print specific worksheets in groups.

What I would like to do is have the macro select a specific printer (CutePDF) instead of printing to the default printer.

So far, if I manually change the default printer on my PC to CutePDF it will bring up the "save as" prompt for each grouping and the file names are all the same.

I want to eliminate having the user change their default printer every time.

Is there a way to change the default printer within the Macro and also only have one 'save as' prompt for the entire macro that will compile and save each grouping?