| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling the Print Form
Possibly one of these:
Application.Dialogs(xlDialogPrint).show application.Dialogs(xlDialogPrinterSetup).Show To demonstrate from the immediate window: ? application.ActivePrinter \\ardaps01\1D343E on Ne02: ? application.Dialogs(xlDialogPrinterSetup).Show ' selected printer G ? application.ActivePrinter \\ardaps01\1D343G on Ne04: -- Regards, Tom Ogilvy "Derek from Belgium" <Derek from wrote in message ... This is probably very easy: how can I call Print Form in a VBA procedure ? I want the user to select his printer. Thanks !! Derek |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print question - Calling Dave Peterson! | Excel Discussion (Misc queries) | |||
| Print question - Calling Dave Peterson! | Excel Discussion (Misc queries) | |||
| Macro (Print) - Calling Named Ranges | Excel Discussion (Misc queries) | |||
| Calling Com addin from form button on sheet? | Excel Programming | |||
| Calling variable from user form | Excel Programming | |||
Threaded Mode
