2003 Email Addresses opens window

  • Thread starter Thread starter Flyer
  • Start date Start date
F

Flyer

I use Office 2003. One of my Excel spreadsheets has a list of email addresses. Whenever I click on one, even to update it, an Outlook New Email message window opens as if I wanted to send an email. How can I change the default not to open the window?
Thanks,
Frank
 
Sounds like the addresses have been defaulted to hyperlinks which is normal
behavior.

If you want to edit one of these, click and hold a couple of seconds until
the little hand changes to a large white +.

You can then edit in the formula bar.


Gord Dibben MS Excel MVP
 
One more thing.

If you don't want these as hyperlinks, run this macro on the selected range.

Sub Delete_Hyperlinks()
Dim Cell As Range
For Each Cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
Cell.Hyperlinks.Delete 'Add anchor:=Cell, _
Next Cell
End Sub

To prevent Excel from treating these as hyperlinks when you enter them in
the future go to Tools>Autocorrect Options>AutoFormat as you type.

Clear the option at Internet and network paths with hyperlinks.


Gord
 
One more thing.

If you don't want these as hyperlinks, run this macro on the selected range.

Sub Delete_Hyperlinks()
Dim Cell As Range
    For Each Cell In Intersect(Selection, _
            Selection.SpecialCells(xlConstants, xlTextValues))
            Cell.Hyperlinks.Delete  'Add anchor:=Cell, _
    Next Cell
End Sub

To prevent Excel from treating these as hyperlinks when you enter them in
the future go to Tools>Autocorrect Options>AutoFormat as you type.

Clear the option at Internet and network paths with hyperlinks.

Gord





- Show quoted text -
Click to expand...

When you need to enter in those cells, Use F2 key instead of mouse.
 
Back
Top