View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Patti Patti is offline
external usenet poster
 
Posts: 45
Default Remove hyperlink in excell 2003

Dave,
I could have sworn that I thought I could right click & remove the links
that way??


"Dave Peterson" wrote:

Kinda VBAish...

select the range with the links (the whole worksheet??)
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete

patti wrote:

HI
I know that their is an EASY way to remove hyperlinks....
I have a whole bunch of emails on a spreadsheet... how without doing like
macos and stuff how do I remove the links????


--

Dave Peterson