| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print Entire workbook problem | Excel Discussion (Misc queries) | |||
| Print Entire Workbook | Excel Discussion (Misc queries) | |||
| Set 'Print Entire Workbook' as default? | Excel Discussion (Misc queries) | |||
| Macro to open print window and set to print entire workbook | Excel Discussion (Misc queries) | |||
| Supress Query Refresh dialog on opening workbook | Excel Programming | |||
Linear Mode
