Print Entire Workbook

G

Guest

Hi,

I'm trying to set the default for excel docs to always default to print
"entire workbook" when it is printed.

Is there a registry entry that I can add or edit for this that anyone know
about? Or even a command line option?

Thanks

Rob
 
D

Dave Peterson

Maybe you could use a macro:

Option Explicit
Sub PrintWorkbook()
ActiveWorkbook.PrintOut
End Sub

And then run that macro whenever you want to print the entire workbook.

(I've never seen a way to change that dialog to default to entire workbook.)
 
G

Guest

Thanks for taking the time to reply.

Unfortunately I can't use the macro as I need to be able to print it without
opening the document (This is required for an automated process)

Thanks

Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print Entire Workbook acting strangely 1
Printing Worksheet/Workbook 2
Set the print order of worksheets when printing entire workbook 2
Printing a workbook but not getting page set-up results 1
Excel is now printing all the entire workbook. 6
Duplex Printing of Workbook with multiple worksheets 2
Not printing the entire workbook 2
Printing entire woorkbook 2

Top