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