Ahhh Dian. You read my mind. I often see reference on this list to VBA and
macros but didn't have a clue how to apply them. You've just given me something
to play with over the weekend. ; ) /g
-----Original Message-----
From: Dian Chapman [mailto:dian@xxxxxxxxxxxxx]
Sent: Fri 6/27/2003 2:01 PM
To: mso@xxxxxxxxxxxxx
Cc:
Subject: [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
*************************************************************
-- Binary/unsupported file stripped by Ecartis --
-- Type: application/ms-tnef
-- File: winmail.dat
*************************************************************
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
*************************************************************