If you have multiple individual sheets within your Excel workbook, when you try to create a PDF and choose to print the Entire Workbook, each sheet will be saved as a different PDF file. Because of this, Excel assumes that how to save excel workbook as pdf individual sheet has to be sent for printing separately, so it will send it in the same way to the PDF printer which will prompt to create a PDF from each sheet. DPI printing value for all of them.
You will have to repeat these steps for each individual sheet in your workbook. However, if you have the same printing settings for each sheet in the workbook, you can change the Page Setup options for all sheets at once. Set the Print Quality to the DPI value you want and press OK so that Excel will record the fact that all pages have the same print settings.
It’s important to press the OK button even if you don’t change anything, because this will “tell” Excel that all the sheets have the same page setup options. Click on File then Print and see if you like the way the pages will show when printed to PDF.
VBA: How to save Excel Workbook to Desktop regardless of user? Sign up or log in to customize your list. Join Stack Overflow to learn, share knowledge, and build your career.
VBA: How to save Excel Workbook to Desktop regardless of user? I have an Excel Workbook that on Form Button click I need to save a copy of the workbook to the user’s Desktop. Originally everything was going to be on a shared Network folder, but now I have about 6 different users that when they click the button, I need to save the workbook to their individual Desktops.
I think this is the most reliable way to get the desktop path which isn’t always the same as the username. Will there need to be any special references, files, enabling needed to run that code on my users machines? I’m not sure whether this would be a requirement, but may help! Thanks for the note, and certainly something worth considering in normal circumstances.