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.
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.
