Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Links with Excel
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 |
#2
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Links with Excel
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 "Jeannine" wrote in message ... 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 |
#3
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Links with Excel
I'm afraid that's way over my head. Instead of that, can I search for
links in the with Search? |
#4
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Links with Excel
Hi Jeannine
Jeannine wrote: 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 -- /"\ ASCII Ribbon Campaign | MS \ / | MVP X Against HTML | for / \ in e-mail & news | Word |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel links in word (resizing) | Microsoft Word Help | |||
Word to Excel links | Microsoft Word Help | |||
Extra space in links to Excel | Microsoft Word Help | |||
Excel links | New Users | |||
Updating Links from Excel to Word | Tables |