query: print dialog with entire workbook set

[KevinGPO]

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

 

[Tom Ogilvy]

sheets.select
application.Dialogs(xlDialogPrint).Show

 

[KevinGPO]

What parameters do you put for Sheets.Select?

sheets.select
application.Dialogs(xlDialogPrint).Show

 

[Tom Ogilvy]

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