View Single Post
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

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