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.