Hyperlink Issues

[JCraig]

For whatever reason every cell in my workbook has a hyperlink on it to an email address. Is there any way to remove all the hyperlinks at once in one sheet? Right now I am removing one at a time. Also, any idea how this could have happened?

 

[Joe4]

I have run into the same situation. It is quite annoying. Anytime you enter an email address in Excel, or edit an email address in Excel, it automatically converts it to a hyperlink. I don't think there is any way to disable that behavior.

However, you can remove them all at once. Take a look at the code in this post: http://www.mrexcel.com/forum/showthread.php?t=467375

 

[JCraig]

Thanks! Is this a VBA code? I'm really only experienced in formula's and some formatting as our spreadsheets are used for accounting purposes. How do I use this code? We do have email addresses that are in there but it's okay that they're hyperlinks. The problem is the entire workbook every cell has turned into a hyperlink when it's basic text not an email address. Very strange.

 

[sulakvea]

copy / paste the entire column into Notepad, and then paste back into Excel

 

[Joe4]

This link will tell how how to get into the VBA Editor and where to place your code: http://www.ehow.com/how_2101765_write-excel-vba-program.html

Once, you have done that, you can run that code from the Macros Toolbar.