dott
I don't have a duplex printer so I use a macro for duplexing.
What problems do you encounter?
How are you selecting all worksheets for printing?
File>Print>Entire Workbook or just selecting all sheets by right-click on a
Tab and "select all sheets"?
Gord Dibben Excel MVP