Evie

There is no default setting for entire workbook.

I would turn on the macro recorder when doing the FilePrintEntire workbook
then assign that macro to a button or shortcut key combo.


Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 15:23:01 -0800, Evie wrote:

I have an Excel form that I use daily. It has 3 worksheets that when
printing, I want to print them all automatically. I cannot find a setting
other than in the Print (Ctrl+P) window that indicates what we want to print
(i.e. entire workbook).

Are there any settings that I can set so that it always prints the entire
workbook?

We are on Excel 2003 SP2