Feb 18 2019 11:49 AM
I can't seem to find a way to permanently change the print settings from print sheet to print workbook. Whenever I open a file, the first time I go to File > Print, I have to change it from print sheet to print workbook. I am printing to PDF and this is becoming a problem. This might be inconsequential to most, but when I have several workbooks open at one time, each with multiple sheets, and I have not changed the settings over on one of those workbooks, I can miss printing a large amount of data to a pdf. To help eliminate user error on my part, I am in need of finding a way to do this. What am I missing? Thank you in advance.
Feb 19 2019 01:14 PM
Hi @marcodel,
I don't see that there's a way to set default print settings (I'd thought maybe you could at the very least save specific print settings like this that you could select from a drop-down, but I'm not seeing that).
What I would recommend is creating a macro for your print settings. This way, you can either choose a shortcut, select the macro from Developer > Macros or assign a macro to a button in your workbook to print exactly how you want to.
Unfortunately, when I tested my basic macro, it did not retain my printer selection, but I found an article that explains multiple ways to write a macro to do this and even includes a sample file at the bottom of the page with the macros already built in, so hopefully this is a decently easy thing for you to do. Link: https://www.contextures.com/excelvbapdf.html
Here's another helpful link with some additional options: https://powerspreadsheets.com/save-excel-file-pdf-vba/
If you're not very familiar with Excel macros, this guy explains them pretty well here: https://youtu.be/XA5CduXRJJ8 What he's showing isn't quite what you want to do, but it's useful information.
Other helpful information:
In Excel, the Visual Basic editor and Macros can be accessed on the Developer tab. If you do not currently see this tab in Excel, you will need to enable it using the following steps:
I hope this helps you find a more efficient way to print your workbooks to Excel!
Feb 21 2019 10:45 PM
Thank you, I will have to look into that. :)