| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
User select printer in print macro
This should be just what you want. It also restores the users default
printer after printing. strOldActivePrinter = Application.ActivePrinter Application.Dialogs(9).Show ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Application.ActivePrinter = strOldActivePrinter Lee |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select printer macro | Excel Worksheet Functions | |||
| members on my network printer not able to print to default printer | Excel Discussion (Misc queries) | |||
| create a pause in print macro to allow user to select printer | Excel Programming | |||
| How do I initiate the windows printer select object in Excel macro | Excel Programming | |||
| My First User Form - How to Select Range(s) and Print | Excel Programming | |||
Threaded Mode
