Printing in MS Word

cithompson

New Member
Joined
Apr 20, 2010
Messages
21
Hi

I am wanting to have a hyperlink on the page, but do not want it printed - any ideas?

Thanks
Chris
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
hi Chris,

If you don't mind the hyperlink being inactive, you could embed it in a field coded as:
{IF{PRINTDATE \@ yyyyMMddHHmm}= {DATE \@ yyyyMMddHHmm} "" "Your hyperlink goes here"}

Notes:
1. The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message.
2. With this approach, you'll need to update the field code after printing for the hyperlink to re-appear, and, depending on the timing, you might have to wait for up to a minute after printing before being able to do this.
 
Upvote 0
It's for Word. The process for creating the field is quite different from formula creation in Excel.
 
Upvote 0
Hi

I am wanting to have a hyperlink on the page, but do not want it printed - any ideas?

Thanks
Chris

As an alternative to Macropod's suggestion, you could simply record a macro that changes the hyperlink to white font. That way when you print it, the text will not print out. Sort of a "cheap" method, but it will get the job done.

If there is only 1 hyperlink in the document, you could try something like this:

Code:
Sub WhiteHyperlinks()
'
' WhiteHyperlinks Macro
'
'
With ActiveDocument
    Selection.EndKey Unit:=wdLine, Extend:=wdExtend
    Selection.Font.Color = -603914241
' **** change the name of the active printer by replacing the text between the quotes below ****
            ActivePrinter = "HP Photosmart 8400 Series"
    Application.PrintOut FileName:="", Range:=wdPrintAllDocument, Item:= _
        wdPrintDocumentContent, Copies:=1, Pages:="", PageType:=wdPrintAllPages, _
        ManualDuplexPrint:=False, Collate:=True, Background:=True, PrintToFile:= _
        False, PrintZoomColumn:=0, PrintZoomRow:=0, PrintZoomPaperWidth:=0, _
        PrintZoomPaperHeight:=0
    Selection.Font.Color = -587137025
    Selection.HomeKey Unit:=wdStory
End With
End Sub

Place your cursor at the very beginning of the hyperlink and press Alt + F8 to run the code.
Also, you'll need to change the name of your printer accordingly.
 
Last edited:
Upvote 0
Hi Chris,

Perhaps, the simplest solution of all, provided you've got Word configured to display but not print hidden text, is to format the hyperlink as hidden text. This will leave the hyperlinks visible and active on screen, without the need for either a field code or a macro. If you modify Word's Hyperlink Style (it's a character Style), so that the font is hidden, then all hyperlinks will be likewise affected.
 
Last edited:
Upvote 0
Hi Chris,

Perhaps, the simplest solution of all, provided you've got Word configured to display but not print hidden text, is to format the hyperlink as hidden text. This will leave the hyperlinks visible and active on screen, without the need for either a field code or a macro. If you modify Word's Hyperlink Style (it's a character Style), so that the font is hidden, then all hyperlinks will be likewise affected.

Chris, Macropod's very smart suggestion is very efficient and much better option than the macro I gave you above.

In order to view (but not print) hidden text, you can follow the steps below -- note that this is for Office 2007 (2010) versions only.
1) Click on the Office orb at the top left corner
2) Choose "Word Options"
3) Click on Display tab on the left.
4) In the right pane, there's a section called "Always show these formatting marks on the screen" -- check the "hidden text" box.
 
Upvote 0

Forum statistics

Threads
1,225,521
Messages
6,185,457
Members
453,292
Latest member
Michandra02

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top