Remove hyperlink feature

D

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
 
D

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.
 
D

Dr. Indera

hi kevin,

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

thanks again.
indera
 
D

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 said:
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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Dr Indera,

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

David McRitchie

Top