Printing Excel Tabs to Adobe PDF

[boonwd]

Greetings to the forum,
i have a situation that's not new to me but i decided to try to find a remedy.
when i attempt to print to a PDF using Adobe more than one tab or sheet from a workbook, Adobe will begin to print the first tab selected and ask “where to and what name”.
it prints the first selected tab and then up pops the “where to and what name window again”. I have to give the second print effort a “dummy” name to get it to move forward, and repeat this until all the selected tabs are printed to PDF.
Once that effort is competed, I have to then combine or bind all the dummy PDFs into a single PDF file, which was my original intent in the first place. I know I can use the “Save to PDF” option within Excel, and achieve the desired results, but when doing so, that process somehow jumbles and shifts around my original tab positions within the Excel workbook.
I have to move them all back to their original locations every time I do a print-to-PDF job.
This could possibly be some setting within Adobe that I am aware of.
Just expressing my situation to the forum in the event others have experienced the same.

 

[ranman256]

select all the tabs to be printed (click each tab holding CTRL key)
THEN print (or export).
they then print in 1 document.

 

[boonwd]

yes, selecting tabs using your method will export or save as a PDF, however this method repeatedly jumbles my tabs out of their original order.
Printing using Adobe as the printer does not jumble my tabs, however it won't print the whole job without stopping and asking "where to and what name" over and over again...