query: print dialog with entire workbook set
 

How can I write a macro to display/show the print dialog box/window, but
with Entire Workbook selected?

query: print dialog with entire workbook set
 

sheets.select
application.Dialogs(xlDialogPrint).Show

--
Regards,
Tom Ogilvy


"KevinGPO" wrote in message
...
How can I write a macro to display/show the print dialog box/window, but
with Entire Workbook selected?

query: print dialog with entire workbook set
 

What parameters do you put for Sheets.Select?


"Tom Ogilvy" wrote in message
...
sheets.select
application.Dialogs(xlDialogPrint).Show

--
Regards,
Tom Ogilvy


"KevinGPO" wrote in message
...
How can I write a macro to display/show the print dialog box/window, but
with Entire Workbook selected?

query: print dialog with entire workbook set
 

sheets.select selects all sheets - I equate this to your requirement "with
Entire Workbook selected"

After reading your question, I now believe you want to display the dialog
with the option button next to "Entire Workbook" to be selected.


so try this instead:

Sub abcd()
ExecuteExcel4Macro "PRINT?(1,,,,,,,,,,,3)"
End Sub

--
Regards,
Tom Ogilvy



"KevinGPO" wrote in message
...
What parameters do you put for Sheets.Select?


"Tom Ogilvy" wrote in message
...
sheets.select
application.Dialogs(xlDialogPrint).Show

--
Regards,
Tom Ogilvy


"KevinGPO" wrote in message
...
How can I write a macro to display/show the print dialog box/window,
but
with Entire Workbook selected?