How can I stop Outlook from automatically opening a new email when I click on an email address in Excel?

[Counselor]

In my Excel spreadsheet I have a column to store the email addresses of my clients. Every time I click on the text of an email address, it automatically opens Outlook with a new message composed to that address. How do I stop this from happening? I don't even use Outlook for my email and this is really frustrating. I've tried changing the format of the column to no avail.

Thank you; your help is most appreciated.

 

[VoG]

Hello and welcome to MrExcel.

Try this with a copy of your sheet. Press ALT + F11 to open the Visual Basic Editor, Insert > Module and paste the following into the white space on the right:

Sub DelHy()
ActiveSheet.Hyperlinks.Delete
End Sub

Press ALT + F11 to return to your sheet, Tools > Macro > Macros, highlight DelHy and click the Run button.

 

[Counselor]

It worked!!!!!

You have saved me hours and hours of frustration.

Thank you, Thank you, Thank you!!!

YOU ROCK!!!!!!!!!

 

[Juansito]

Dear Vog:
I registered in this website just to thank you for this miraculous solution. As the Counselor says,
You have saved me hours and hours of frustration.

Thank you, Thank you, Thank you!!!

YOU ROCK!!!!!!!!!

 

[Peter_SSs]

@Juansito
Welcome to the MrExcel board!
If you wanted to keep the hyperlink option available, you can also do a 'slow click'. That is, just hold the mouse button for a bit longer than usual when you click on the cell with the hyperlinked email address.