|
|
|
|
|
|
Word
|
Selecting from multiple printer options
|
|
Ease of Use
|
Intermediate
|
Version tested with
|
2000
|
Submitted by:
|
mdmackillop
|
Description:
|
After initial setting up by the user, the document you wish to print should come out on the correct paper without the need for changing printer settings, or even selecting the printer.
|
Discussion:
|
Where letters, reports, drafts have to be sent to different printers or use different trays for letterheads, continuation sheets etc. you need a simple interface to make life easy; and why not add the "SpellCheck Before Print" KB entry into the procedure.
|
Code:
|
instructions for use
|
Sub ShowPrintSelector()
PrintSelector.Show
End Sub
Or
Sub ShowPrintSelector()
ActiveDocument.CheckSpelling
PrintSelector.Show
End Sub
|
How to use:
|
- Open the attached document
- In the VBE, drag the PrintSelector userform to the Normal project.
- Add the either code above to a module within Normal
- Assign Control + P or a button to the ShowForm macro
- Change the Const values within the Userform code to the printer names on your system.
- Alter the printer tray settings to suit your own requirements.
- Persevere. It's worth it in the end!
|
Test the code:
|
- Test each print option to ensure it's doing what you want.
|
Sample File:
|
PrintSelector.zip 35.59KB
|
Approved by mdmackillop
|
This entry has been viewed 121 times.
|
|