Want PRINT ENTIRE WORKBOOK to be the default every time - how do I change that?

[thcguy12]

Right now every time I open an excel file (we have thousands) the print dialog box defaults to print active sheets.

Well I need to print something on the second sheet - how do I either ACTIVATE both sheets always without an extra step OR change the default in the print box to PRINT ENTIRE WORKBOOK for all jobs moving forward without having to change it manually each time?

[JBeaucaire]

There is no "setting" I know of to make the edit you're looking for. But it can be worked around. You can create a macro and store it in your PERSONAL.XLSB file so it's available all the time.

Please Login or Register  to view this content.

When you run that macro it will instantly print the entire workbook.

[JBeaucaire]

How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Look on the left and find your PERSONAL.XLSB project, then doubleclick to select it.
4. Insert a new module (Insert > Module)
5. Copy and Paste in your code (given above)
6. Get out of VBA (Press Alt+Q)
7. Close Excel completely and say "yes" when it offers to save your updated PERSONL file.
8. When you next open Excel, that macro will be available.

The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.
Or try adding a button to your toolbar connected to that macro for click-ease.

[thcguy12]

So in other words I still have to push some MACRO button before it will work?

If I was willing to push a button every time why wouldn't I just push the PRINT ALL WORKBOOKS button?

I need this to work automatically when any user opens it to print the whole workbook OR both sheets without any extra steps on their part.

[thcguy12]

If there was a way to add a PRINT ALL button to the top of my computer AND my associates computer that might work but he won't push ALT F8 every time - I know he wont.

[JBeaucaire]

I'm offering a you a solution that in the end should be even shorter than your original ask, which would still be multiple steps even if the intermediate print dialog was already set to Print Workbook.

A single click macro is far fewer steps than you currently have to open the print window, change to Print Workbook (or not), and click Print.

You could install the macro into the workbook itself and assign a hotkey, like CTRL+P.

[thcguy12]

Maybe I am not understanding.

I added the Macro. I then added a button to my toolbox. When I hit that button it does not start printing (step1). It opens up another dialog box that asks me to run the macro (step 2).

The old way of doing it would be to change the print box to ENTIRE WORKBOOK (step 1) and then hit the print button (step 2).

So I am not seeing where this saves time.

I am dull when it comes to this - I am probably missing something - should it just start printing when I hit something - I would like it to be a ONE STEP print all of workbook situation - does that make sense?

[JBeaucaire]

Interesting. When I run that macro the currently active workbooks prints out with no dialog.