Links with Excel

J

Jeannine

I have some (many, actually) links in my Word 2003 doc to an Excel 2003 doc.
Can I format the Word links (data from Excel) so they show up prominently
while I'm drafting the doc and then get rid of the highlighting (or
whatever) when I get to the final draft?
Thanks, Jeannine
 
D

Doug Robbins - Word MVP

Running the following macro will make them bold

Dim alink As Field
Dim linkcode As Range

For Each alink In ActiveDocument.Fields
If alink.Type = wdFieldLink Then
Set linkcode = alink.Code
linkcode.Font.Bold = True
End If
Next alink

Changing the True to False and running it again will set them back to normal
text.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
J

Jeannine

I'm afraid that's way over my head. Instead of that, can I search for
links in the with Search?
 
R

Robert M. Franz (RMF)

Hi Jeannine
I have some (many, actually) links in my Word 2003 doc to an Excel 2003 doc.
Can I format the Word links (data from Excel) so they show up prominently
while I'm drafting the doc and then get rid of the highlighting (or
whatever) when I get to the final draft?
Click to expand...

if they are ordinary hyperlinks, you could adjust the HYPERLINK
character style of your document. Format | Styles and Formatting, then
locate the style, and make it purple/embossed/marching red ants (or
something like that :)).

2cents
Robert
 
Top