| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print specific range but user to select printer
Hi
This will save Default printer, let user print out on selected printer and return to default printer. MyPrinter = ActivePrinter Application.Dialogs(8).Show ' Show Printer Dialog! Worksheets("Disinfections").Range("pen_list").Prin tOut Application.ActivePrinter = MyPrinter Happy New Year! Per "Code Numpty" skrev i meddelelsen ... Hi, I have the following in one of my macros to print to the default printer. Worksheets("Disinfections").Range("pen_list").Prin tOut How do I change this so that the print dialog box pops up to allow the user to select the printer and page size? Happy New Year! (nearly) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to select a specific range based on the time value of user form input | New Users to Excel | |||
| User select printer in print macro | Excel Programming | |||
| User select printer in print macro | Excel Programming | |||
| create a pause in print macro to allow user to select printer | Excel Programming | |||
| My First User Form - How to Select Range(s) and Print | Excel Programming | |||
Threaded Mode
