[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 349
  • Last Modified:

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

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.

-Sherman6789
0
sherman6789
Asked:
sherman6789
  • 4
  • 2
1 Solution
 
Rgonzo1971Commented:
No attachment
0
 
Rgonzo1971Commented:
Hi,

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

Regards
0
 
sherman6789Author Commented:
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.  

sherman6789
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Rgonzo1971Commented:
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
    Else
        ContentCtrl.Range.Font.Hidden = False
    End If
Next
Application.Options.PrintHiddenText = False
Application.PrintOut
End Sub

Open in new window

Regards
0
 
sherman6789Author Commented:
I forgot to ask, where do I put the VBA statements?
0
 
Rgonzo1971Commented:
in a module

Alt-F11 then

Right-click your Document Project Insert Module

And paste

Regards
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now