Links with Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeannine - 21 May 2007 18:25 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 21 May 2007 18:42 GMT

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.

Signature

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

>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

Reply to this Message

Jeannine - 21 May 2007 18:54 GMT

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

Reply to this Message

Robert M. Franz (RMF) - 21 May 2007 20:58 GMT

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?

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

Signature

/"\ ASCII Ribbon Campaign | MS
\ / | MVP
X Against HTML | for
/ \ in e-mail & news | Word

Reply to this Message