I am trying to get a print macro for Word XP that will let me print a document to headed paper in tray 1 and then to plain paper in tray 2, can anyone give me any help on this?
Thanks
Simon.
I am trying to get a print macro for Word XP that will let me print a document to headed paper in tray 1 and then to plain paper in tray 2, can anyone give me any help on this?
Thanks
Simon.
Hi Simon,
Welcome to VBAX
Here's a simplified version of what I use. You'll need to determine the correct constant values for your printer, which you can do by recording a macro changing the paper source in Page Setup. The Userform format gives much more flexibility and options than individual macros.
I also created a KB item for changing printers which may be of interest if you need watermark etc. options.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Thanks for that, I have opened the document but I am unable to edit the macro as it does not appear in the macro list. May be a stupid question but how do I edit the Macro?
Simon.
The code is contained in a Userform
Press Alt + F11 to enter the Visual Basic Editor (VBE)
In the Left pane, within the Project should be a Forms folder. Open this folder.
There should be a form PrintSelector. Select this and click View/Code.
Remember to save your changes on completion.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'