You can remove the hyperlinks from a selected area by running a small macro:
option Explicit
sub removeLinks()
selection.hyperlinks.delete
end sub
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
chits wrote:
Please note: i am having Macros disabled in this sheet by the system & i cant
change the settings to enable it.
"chits" wrote:
I have several cells in my worksheet which is having a Hyperlink..
I want to remove this hyperlink for all the cells in that row..
is this possible through a single command?
currently i have to select each & every cell - right click & remore link
individually?
i have the text in different fonts for this row, Is it possible to remove
hyperlinks for all at a strech retaining the font?
Thanks,
Chitra
--
Dave Peterson