Email addresses in cells

Phylis Sophical · Apr 22nd, 2002, 01:33 AM

I have a column that contains email addresses. If I click on the cell, it brings up a blank email with the persons address in it. (Outlook Express).
Is there a way to block that column from executing the email thing?

gareth · Apr 22nd, 2002, 01:37 AM

Yes there is.If you remove the Hyperlink from your Column,you will be able to browse in the column without going to the e-mail link

Penfold · Apr 22nd, 2002, 01:46 AM

You can remove the hyperlinks one by one by right clicking on the cell and choosing remove hyperlink from the menu.

If you have a whole column then the best way to get rid of the lot of 'em is to highlight the range and click on Format, Style and then select Normal from the list box at the top.

Regards,

Penfold

Phylis Sophical · Apr 22nd, 2002, 01:51 AM

You know this is sooooo much easier than trying to figure out where to find the info in a mannual. Thanks so much for the prompt responses.

Phylis Sophical · Apr 22nd, 2002, 02:15 AM

Just an added note here Penfold, When trying to change the whole range by using styles, it did take the blue color and line underneath out, but it still links when clicked on. Unless I did something wrong, I guess to totally deactivate them, I'll have to do the right click thing individually. Feel free to correct me if I'm wrong.

Penfold · Apr 22nd, 2002, 03:36 AM

Good point, I hadn't really noticed as the main issue I had in the past was that it was blue and underlined!

I can't readily find a method quicker than doing it one by one, but remember to use the extremely useful "Repeat" function in Excel (either Ctrl-Y or better still, F4). That is, do it once using the right click method and then arrow down one cell, hit F4, down, F4 etc etc.

Penfold

Phylis Sophical · Apr 22nd, 2002, 03:45 AM

That worked Pen. Thanks. I always feel so much smarter (advanced) if I can use an F key.

[ This Message was edited by: Phylis Sophical on 2002-04-22 02:46 ]

PennyWeiss · Apr 26th, 2002, 02:59 PM

I have a column that's 700 entries long.. still no way to remove the hyperlink on a range??

Aladin Akyurek · Apr 26th, 2002, 03:09 PM

Quote:

On 2002-04-26 13:59, PennyWeiss wrote:
I have a column that's 700 entries long.. still no way to remove the hyperlink on a range??

Try ASAP-Utilities, free downloadable from:

http://asap-utilities.com

Aladin

Phylis Sophical · Apr 26th, 2002, 10:15 PM

Just ran across this Penny:

To create the macro, press Alt-F11 to activate the Visual Basic Editor, select Insert, Module to insert a new VBA module into your project, and then enter the following code:

Sub ZapHyperlinks()
Cells.Hyperlinks.Delete
End Sub
When you execute the ZapHyperlinks macro, all hyperlinks on the active sheet are deleted and replaced with normal text.

found this at:
http://j-walk.com/ss/excel/usertips/tip031.htm

[ This Message was edited by: Phylis Sophical on 2002-04-26 21:16 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 22nd, 2002, 01:33 AM	#1
Phylis Sophical New Member Join Date: Jan 2002 Location: Canada Posts: 42	I have a column that contains email addresses. If I click on the cell, it brings up a blank email with the persons address in it. (Outlook Express). Is there a way to block that column from executing the email thing?

Apr 22nd, 2002, 01:37 AM	#2
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	Yes there is.If you remove the Hyperlink from your Column,you will be able to browse in the column without going to the e-mail link

Apr 22nd, 2002, 01:46 AM	#3
Penfold New Member Join Date: Mar 2002 Location: Australia Posts: 43	You can remove the hyperlinks one by one by right clicking on the cell and choosing remove hyperlink from the menu. If you have a whole column then the best way to get rid of the lot of 'em is to highlight the range and click on Format, Style and then select Normal from the list box at the top. Regards, Penfold

Apr 22nd, 2002, 01:51 AM	#4
Phylis Sophical New Member Join Date: Jan 2002 Location: Canada Posts: 42	You know this is sooooo much easier than trying to figure out where to find the info in a mannual. Thanks so much for the prompt responses.

Apr 22nd, 2002, 02:15 AM	#5
Phylis Sophical New Member Join Date: Jan 2002 Location: Canada Posts: 42	Just an added note here Penfold, When trying to change the whole range by using styles, it did take the blue color and line underneath out, but it still links when clicked on. Unless I did something wrong, I guess to totally deactivate them, I'll have to do the right click thing individually. Feel free to correct me if I'm wrong.

Apr 22nd, 2002, 03:36 AM	#6
Penfold New Member Join Date: Mar 2002 Location: Australia Posts: 43	Good point, I hadn't really noticed as the main issue I had in the past was that it was blue and underlined! I can't readily find a method quicker than doing it one by one, but remember to use the extremely useful "Repeat" function in Excel (either Ctrl-Y or better still, F4). That is, do it once using the right click method and then arrow down one cell, hit F4, down, F4 etc etc. Penfold

Apr 22nd, 2002, 03:45 AM	#7
Phylis Sophical New Member Join Date: Jan 2002 Location: Canada Posts: 42	That worked Pen. Thanks. I always feel so much smarter (advanced) if I can use an F key. [ This Message was edited by: Phylis Sophical on 2002-04-22 02:46 ]

Apr 26th, 2002, 02:59 PM	#8
PennyWeiss New Member Join Date: Apr 2002 Location: Penny Weiss Posts: 1	I have a column that's 700 entries long.. still no way to remove the hyperlink on a range??

Apr 26th, 2002, 10:15 PM	#10
Phylis Sophical New Member Join Date: Jan 2002 Location: Canada Posts: 42	Just ran across this Penny: To create the macro, press Alt-F11 to activate the Visual Basic Editor, select Insert, Module to insert a new VBA module into your project, and then enter the following code: Sub ZapHyperlinks() Cells.Hyperlinks.Delete End Sub When you execute the ZapHyperlinks macro, all hyperlinks on the active sheet are deleted and replaced with normal text. found this at: http://j-walk.com/ss/excel/usertips/tip031.htm [ This Message was edited by: Phylis Sophical on 2002-04-26 21:16 ]