Remove hyperlink feature

[Dr. Indera]

hello,

i have email and web site addresses in a spreadsheet. some are hyperlinks
and some are not. how do i change them, so that they are not hyperlinks or
blue?

thank you
indera

 

[Kevin Stecyk]

Dr Indera,

Here's one way: http://j-walk.com/ss/excel/usertips/tip031.htm

Good luck.

Regards,
Kevin

 

[David McRitchie]

Hi Indera,
If you want to retain any of the hyperlinks then you would
have to modify that macro to use selection. rather than cells.
so that you can zap the hyperlinks only in the selection.

 

[Dr. Indera]

hi kevin,

thank you so much.
yes, i am using excel 2000.
the macro worked as promised.

thanks again.
indera

 

[Dr. Indera]

hi kevin,

for this spreadsheet, i do not want any hyperlinks.
for other spreadsheets, modifying the macro would be a good option.

thank you
indera

 

[David McRitchie]

Hi Indera,
You can use the modified macro to remove all hyperlinks if you
first use Ctrl+A to select allcells before you run the macro.
This would simply things for all usages clearing object type
hyperlinks as there would only be one macro. Should have
mentioned that.

Incidentally my pages on aspects of hyperlinks are
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#DelHyperlinks
http://www.mvps.org/dmcritchie/excel/sheets.htm#hyperlink
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm