Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to view 'Print' dialog box
Hi -
I need to use a macro to bring up the same dialog box that appears when you select 'Print...' from the File menu. I tried to record a macro to see the code, but it only gives code for 'Ok, go ahead and print with these options' rather than just displaying the dialog box, and awaiting user input. Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to view 'Print' dialog box
Hi Jakey,
Try: Application.Dialogs(xlDialogPrint).Show --- Regards, Norman "JakeyC" wrote in message oups.com... Hi - I need to use a macro to bring up the same dialog box that appears when you select 'Print...' from the File menu. I tried to record a macro to see the code, but it only gives code for 'Ok, go ahead and print with these options' rather than just displaying the dialog box, and awaiting user input. Any ideas? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to view 'Print' dialog box
Job's a good 'un.
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to view 'Print' dialog box
Job's a good 'un.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print dialog box selection macro | Excel Discussion (Misc queries) | |||
Custom Macro View/Print Toolbar for Calendar | Excel Discussion (Misc queries) | |||
column is hidden in normal view but not print view | Excel Worksheet Functions | |||
How do i get the print dialog box to appear in a macro? Help!!! | Excel Programming | |||
Hiding print dialog box within macro | Excel Programming |