Code to Print page 2 only

Bursal · #1 05-05-2016, 04:43 PM

I have been asked to create a number of templates for a NfP organisation. The first page of these templates are info and instructions and I don't want it to print. Rather than getting users to use 'print current page' I would like code to print page 2 only so that when the print button is selected the code will be activated.

Thanks for reading my post and hope you can help me.
Bursal

gmayor · #2 05-05-2016, 09:58 PM

Save the templates as macro enabled and add the following macros to the templates. the macros will intercept the Print commands and print only page 2

Code:

Option Explicit

Sub FilePrint()
    Application.PrintOut Filename:="", _
                         Range:=wdPrintRangeOfPages, _
                         copies:=1, _
                         Pages:="2"
End Sub

Sub FilePrintDefault()
    Application.PrintOut Filename:="", _
                         Range:=wdPrintRangeOfPages, _
                         copies:=1, _
                         Pages:="2"
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Field Code won't print an image	John Sutton	Word	4	07-28-2014 08:40 AM
Copy / Print Merge code	ScottA	Mail Merge	4	06-06-2014 07:32 PM
vba Code to Print Spreadsheet to PDF	OTPM	Excel Programming	3	05-25-2011 08:22 AM
Modify vba code to print based on name in the InputBox	OTPM	Project	0	05-25-2011 02:03 AM
VBA Code to Print Individual Resource Lists to a pdf File	OTPM	Project	0	05-24-2011 12:21 PM