| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printer Dialogue
Is it possible to get a value from the printer dialogue box? What I am trying
to do is to get the user to select the printer that they want from the dialogue box which is displayed using Application.Dialogs(xlDialogPrinterSetup).Show. I would like this printer then to be shown on an excel sheet. Is this possible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printer Dialogue
if Application.Dialogs(xlDialogPrinterSetup).Show < False then
Cells(1,1).Value = Application.ActivePrinter End if -- Regards, Tom Ogilvy "steveh" wrote in message ... Is it possible to get a value from the printer dialogue box? What I am trying to do is to get the user to select the printer that they want from the dialogue box which is displayed using Application.Dialogs(xlDialogPrinterSetup).Show. I would like this printer then to be shown on an excel sheet. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dialogue Box | Excel Discussion (Misc queries) | |||
| members on my network printer not able to print to default printer | Excel Discussion (Misc queries) | |||
| Printer Multiple Worksheets with a particular Printer Setting | Excel Worksheet Functions | |||
| dialogue pop up | Excel Discussion (Misc queries) | |||
| Dialogue Box | Excel Programming | |||
Linear Mode
