Print Entire Workbook

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.)
 
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
 
Back
Top