Permanently changing print settings

[marcodel]

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.

[#2]

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:

1. Click on File > Options
2. Click on Customize Ribbon, then check the box next to Developer under Main Tabs
3. Click on Trust Center > Trust Center Settings
4. Under Macro Settings, select “Enable all macros”
5. Under Developer Macro Settings, check the box next to “Trust access to the VBA project object model”
6. Click on OK
7. The Developer tab will now be available

I hope this helps you find a more efficient way to print your workbooks to Excel!

[#3]

Thank you, I will have to look into that. :)