See inline comments...

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.

No where in my posting did I select all the sheets in the workbook (not did
I say the user should do that manually either)... the single line of code I
posted simply calls up the print dialog box with the option to print all the
sheets selected **in the dialog box only**... this does not select any
sheets in the workbook nor is it dependent on that being done.

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.

I actually had that option working... once... but when I experimented with
other settings, I found I could no longer make the "select whole workbook"
option work again. Not being sure why this was the case, I figured it was
safer to offer the method I posted which always worked for me no matter what
other settings I tried.

--
Rick (MVP - Excel)


This seems to work...

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


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 ???