Luc

Group selection of a number of sheets is a nice feature especially for
printing but note that it can also be a very dangerous feature and that I
suggest that after closing the print dialog you have code to select only one
sheet so as to avoid corruption in active but not visible sheets.

Within the print dialog there is the ability to select the whole workbook -
a better idea would be to be able to open the dialog with that option set and
if someone can enlighten one on how I would be very pleased.
--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"


"Rick Rothstein" wrote:

This seems to work...

Application.Dialogs(xlDialogPrint).Show 2,1,ThisWorkbook.Sheets.Count

--
Rick (MVP - Excel)


"Luc" wrote in message
...
Hoi there,

I want to use the code "Application.Dialogs(xlDialogPrint).Show", but by
default i would like that 'All the worksheets" are selected when this
dialog opens.

Can it be done ???


Thanks,

Luc

.