Set print area for Adobe pdf on 2 separate sheets via macro

I have sheet1 that has a set print area, about 6 Portrait pages.

Sheet2 is about 5 Landscape pages long as its set print area.

I am trying to print all sheet print areas to a single pdf using Adobe pdf pro.

How i have been trying to achieve this is by >File>Print> and selecting ENTIRE WORKBOOK

However it seems to create a pdf doc for sheet1 and prompts for a name.
Then prompts again for the sheet2.

Is there a way to set the print area's across both sheets via vba then the user can then simple select File>Print and both sheets are created as a single pdf doc ?

I have now setup Named Ranges to specify each scenario of printing options across both worksheets.

If i specify what pages across both sheets in a macro, will both sheets be printed to pdf in a single file ?

Ended up using

Please Login or Register  to view this content.

, setting the workbook as the print range, and having the user select the pdf printer from the list of available printers.