query: print dialog with entire workbook set

K

KevinGPO

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

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
 
Top