View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tomj Tomj is offline
external usenet poster
 
Posts: 1
Default Need macro help to edit hyperlinks


Please help. I have a workbook with columns of email hyperlinks that
imported from another program.

When I run following macro: My cells show what is in the "Text t
display field". I need to see the email address.

I have spent many hours searching the web for a macro to do this but
cannot find one. And I do not know how to do it my self.

Thanks,

Sub RemoveHyperlinks()

'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete

End Su

--
Tom
-----------------------------------------------------------------------
Tomj's Profile: http://www.excelforum.com/member.php...fo&userid=2954
View this thread: http://www.excelforum.com/showthread.php?threadid=49245