| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting printer in a macro
thanks...worked great!
"Bob Phillips" wrote: I would use the built-in constant application.Dialogs(xldialogprint).show -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Stephen C" wrote in message ... Application.Dialogs(9).Show "lohme" wrote: I have a macro that does some page formatting, prints the document, and then reformats the page. Now I have a designated printer but would like to have the ability to pick which printer I want to use then continue with the reformating. How do I do this?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting all cells using macro | Excel Discussion (Misc queries) | |||
| Excel Macro - change printer | Excel Discussion (Misc queries) | |||
| How to stop Excel remembering/loading macro from previously opened Workbook | Excel Discussion (Misc queries) | |||
| Selecting from a Validation Drop Down Box aborts macro | Excel Worksheet Functions | |||
| Calculate commissions | Excel Worksheet Functions | |||
Hybrid Mode
