hyperlinks in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am using office 03 for the first time. how does one prevent e-mail
addresses from becoming hyperlinks and eliminate those that are already in
that format. thank you.

mike nolan
 
Mike

To prevent in the future........

Tools>Autocorrect Options>Autoformat as you type. Uncheck the "replace as you
type" box.

To get rid of current ones you can edit manually or run a macro on a selected
range.

Sub removeAllLinksFromSelection()
Selection.Hyperlinks.Delete
End Sub


Gord Dibben Excel MVP

On Mon, 10 Jan 2005 14:03:02 -0800, "Mike Nolan" <Mike
 
Back
Top