Can Excel settings default to always print entire workbook?

E

Evie

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
 
G

Gord Dibben

Evie

There is no default setting for entire workbook.

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


Gord Dibben MS Excel MVP
 
Top