How do we remove the "Click Here" notes from Pull-downs in a MS Word table template when printing?

Posted on 2014-08-26
Last Modified: 2014-09-04
We have created a Microsoft Word Template where the users fill-in blanks and select items from "drop-down" Lists.  The drop-down lists have a entry notification reminder such as "Choose An Item", "Click here to enter text", or "Click here to enter a date".  Since many times a completed template will have many drop-down areas left empty, on purpose, we would like to have those "reminders" to not appear on the sheet when printed.

A modified small version of a template is attached.

Is there a fairly simple way that those reminders can be seen on the screen but not printed when the pull-down is left blank?

Thank you for your assistance.

Question by:sherman6789
    LVL 47

    Expert Comment

    No attachment
    LVL 47

    Expert Comment


    One way to do it is to give the instruction in the title of the drop-down  and as first element of the list a blank space


    Author Comment

    Thank you Rgonzo1971.

    I entered "Choose an Item" in the title area.  That worked well.  I then deleted the first item on the list: "Choose an item".  Next I added a blank line and moved it up to the top space.  When I looked at the results, the original "Choose an tem" returned.  I did not return to the list.  I could not find where the program obtained the statement again.  I then replaced the blank line with "....." five dots.  The same thing happened.  What ever I put on the tope line shows up on the pull down list but the original "Choose and item" still shows up on the pull down box regardless.  

    Tonight, I am going to avoid erasing the original top line and to modify it.  Maybe that will allow the system to replace the statement with what I put on the top line.

    I will let you know what happens tomorrow. Thanks for your assistance.  

    LVL 47

    Accepted Solution

    You could use a bit of vba

    to print it and hide the text when it is the same as the PlaceholderText

    Sub HidePlaceholderTextToPrint()
    For Each ContentCtrl In ActiveDocument.ContentControls
        If ContentCtrl.PlaceholderText = ContentCtrl.Range.Text Then
            ContentCtrl.Range.Font.Hidden = True
            ContentCtrl.Range.Font.Hidden = False
        End If
    Application.Options.PrintHiddenText = False
    End Sub

    Open in new window


    Author Comment

    I forgot to ask, where do I put the VBA statements?
    LVL 47

    Expert Comment

    in a module

    Alt-F11 then

    Right-click your Document Project Insert Module

    And paste


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
    Companies keep a much closer eye on costs today, so changing to new Technology – Microsoft Office 365 is the smartest move to take.
    The viewer will learn how to edit text. This includes Font, Spacing, Resizing, Color, and other special text options.
    The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.

    761 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

    8 Experts available now in Live!

    Get 1:1 Help Now