K KevinGPO Feb 28, 2006 #1 How can I write a macro to display/show the print dialog box/window, but with Entire Workbook selected?
How can I write a macro to display/show the print dialog box/window, but with Entire Workbook selected?
K KevinGPO Mar 1, 2006 #3 What parameters do you put for Sheets.Select? Tom Ogilvy said: sheets.select application.Dialogs(xlDialogPrint).Show Click to expand...
What parameters do you put for Sheets.Select? Tom Ogilvy said: sheets.select application.Dialogs(xlDialogPrint).Show Click to expand...
T Tom Ogilvy Mar 1, 2006 #4 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
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
