How do I de-activate hyperlink in Excel ?
 

I am creating a spreadsheet that has email addresses and web-sites in some
cells.
I don't want them to appear as hyperlink. I know to remove hyperlink by
right clicking on a cell but I want to learn how to de-activate hyperlink in
the worksheet.

How do I de-activate hyperlink in Excel ?
 

try this code
activesheet.hyperlinks.delete
it will remove all the hyperlinks in the active sheet.


"Nik" wrote in message
...
I am creating a spreadsheet that has email addresses and web-sites in some
cells.
I don't want them to appear as hyperlink. I know to remove hyperlink by
right clicking on a cell but I want to learn how to de-activate hyperlink
in
the worksheet.

How do I de-activate hyperlink in Excel ?
 

Take a look here

http://www.mcgimpsey.com/excel/nohyperlinks.html

In article ,
Nik wrote:

I am creating a spreadsheet that has email addresses and web-sites in some
cells.
I don't want them to appear as hyperlink. I know to remove hyperlink by
right clicking on a cell but I want to learn how to de-activate hyperlink in
the worksheet.