Solved

Automate printing selected sections in a protected Word form

Posted on 2008-06-23
2
234 Views
Last Modified: 2010-04-21
Hi,

I am using MS Word 2003.  I have created a protected form with several pages and sections.  I have a section towards the middle of the form that contains internet links and instructions about the form.   I would prefer that this section doesn't print when the completed form is printed by the users.  I know that you can include or exclude sections and pages using the print form page range feature.  But, is there a way to exclude this section automatically (maybe using some VB code) so that my users don't have to be reminded to use the page range feature to exclude this section?

Thanks.
0
Comment
Question by:Delano29
2 Comments
 
LVL 9

Accepted Solution

by:
JonMny earned 500 total points
ID: 21848578
You could use the before print to set the range.

Public WithEvents oApp As Word.Application


Private Sub oApp_DocumentBeforePrint(ByVal Doc As Document, Cancel As Boolean)
'add code to set range here
End Sub


see link

http://word.mvps.org/faqs/macrosvba/AppClassEvents.htm
0
 

Author Closing Comment

by:Delano29
ID: 31469806
Thanks for pointing me in the right direction.  I'll look into the info. in the link as well and do some experimenting.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now