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


Rob Hudson wrote:

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

--

Dave Peterson