Can Excel settings default to always print entire workbook?
 

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

Can Excel settings default to always print entire workbook?
 

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