hyperlinks

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I want to insert and modify email addresses in an Excel
spreadsheet without the addresss turning into a
hyperlink. Is this possible?
 
I'd let them get made and then clean them up with either a macro or something
like this:

Select your range to clean up (ctrl-A will get the whole sheet).

Hit alt-F11 to get to the VBE
hit ctrl-G to see the immediate window
type in
selection.hyperlinks.delete
and hit enter.

a macro would look something like:

sub test()
selection.hyperlinks.delete
end sub
 
Back
Top