E-Mail Issue in Excel
 

An Excel spreadsheet was sent to me by a superior in my office. There are
E-Mail addresses in one column. There are multiple columns that when you try
to click on and/or enter data into, a new mail message opens up in Outlook to
one of those email addresses. I can not figure out how to get this to stop
and neither can my superior.

E-Mail Issue in Excel
 

If you are comfortable with VBA, just highlight your data and type
"Selection.hyperlinks.delete" in the immediate window.

1. Hit Alt-F11 to bring up the VB Editor
2. Ctrl-G to bring up the Immediate Window
3. type "selection.hyperlinks.delete" and hit enter

The hyperlinks should be gone.


HTH,
JP

On Nov 13, 1:35 pm, Susan wrote:
An Excel spreadsheet was sent to me by a superior in my office. There are
E-Mail addresses in one column. There are multiple columns that when you try
to click on and/or enter data into, a new mail message opens up in Outlook to
one of those email addresses. I can not figure out how to get this to stop
and neither can my superior.

E-Mail Issue in Excel
 

"Susan" wrote:

An Excel spreadsheet was sent to me by a superior in my office. There are
E-Mail addresses in one column. There are multiple columns that when you try
to click on and/or enter data into, a new mail message opens up in Outlook to
one of those email addresses. I can not figure out how to get this to stop
and neither can my superior.

Try this:
1) right click on the cell with the email
2) select "remove hyperlink"
3) click on the "format painter icon"
4) select the colums with the email addresses. This should remove the
hyperlinks.

E-Mail Issue in Excel
 

Thanks for the quick solution. This worked great!

"JP" wrote:

If you are comfortable with VBA, just highlight your data and type
"Selection.hyperlinks.delete" in the immediate window.

1. Hit Alt-F11 to bring up the VB Editor
2. Ctrl-G to bring up the Immediate Window
3. type "selection.hyperlinks.delete" and hit enter

The hyperlinks should be gone.


HTH,
JP

On Nov 13, 1:35 pm, Susan wrote:
An Excel spreadsheet was sent to me by a superior in my office. There are
E-Mail addresses in one column. There are multiple columns that when you try
to click on and/or enter data into, a new mail message opens up in Outlook to
one of those email addresses. I can not figure out how to get this to stop
and neither can my superior.

E-Mail Issue in Excel
 

Glad we could help!

--JP

On Nov 15, 9:46 am, Susan wrote:
Thanks for the quick solution. This worked great!



"JP" wrote:
If you are comfortable with VBA, just highlight your data and type
"Selection.hyperlinks.delete" in the immediate window.

E-Mail Issue in Excel
 

I had the same problem, and JP's solution was perfect! Thank you!

"Susan" wrote:

An Excel spreadsheet was sent to me by a superior in my office. There are
E-Mail addresses in one column. There are multiple columns that when you try
to click on and/or enter data into, a new mail message opens up in Outlook to
one of those email addresses. I can not figure out how to get this to stop
and neither can my superior.