2003 Email Addresses opens window

[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

 

[Gord Dibben]

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

 

[Gord Dibben]

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

 

[Ajay]

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 -

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