| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User select printer in print macro
maybe this will help, say there was a choice of 2 printers, and you have a check box to select which printer to print from Code: -------------------- 'deterime which printer to print from If Range("A1") = true then myprinterselect = "\\BTBEAPAPP04\PBTBEA001M" If Range("A2") = true then myprinterselect = "\\BTBEAPAPP04\PBTBEA002M" Dim sCurrentPrinter As String sCurrentPrinter = ActivePrinter wrd.ActivePrinter = my printer select -------------------- works for me anyway, good luck :) -- rocket0612 ------------------------------------------------------------------------ rocket0612's Profile: http://www.excelforum.com/member.php...o&userid=19492 View this thread: http://www.excelforum.com/showthread...hreadid=530690 |
| 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 | |||
![rocket0612[_11_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
