[mso] Re: Excel & Word - Getting rid of Hyperlinks

For Word, you can use this Macro...

'********
Sub RemoveHyperlinks()

Dim HLink As Field
For Each HLink In ActiveDocument.Fields
If HLink.Type =3D wdFieldHyperlink Then
    HLink.Unlink
End If
Next HLink

End Sub
'*********

Don't know about your Excel Qs, however, you might want to post that =
again,
separately.=20

This TechTrax article will tell you what to do with the macro to make it
work...=20

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=3D166


Dian Chapman
Technical Consultant
& Microsoft MVP

Free Word Tips & Tricks eBook: http://www.mousetrax.com/books.html
Free Tutorial site: http://www.mousetrax.com/techpage.html
Free Support Ezine: http://www.mousetrax.com/techtrax/
 =20



-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On =
Behalf
Of Sallie
Sent: Friday, June 27, 2003 11:05 AM
To: Microsoft Users Group

As it turns out, I didn't ask the question correctly.
Does anyone know how to get rid of the Hyperlinks without having to =
right
click on each email and choosing "remove hyperlink"?. =20

I've got hundreds of emails that I need to get rid of the hyperlinks
completely - not just the Underline. =20

Also, is there a way in Excel to set up a column in advance so that =
email
addresses won't have Hyperlinks?

Thank you,
Sallie Bourgeois
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx =
or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to =
mso-request@xxxxxxxxxxxxx
with the word "unsubscribe" (without the quotes) in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will =
also
allow you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, =
send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an =
invitation
with instructions.  Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: