I have a wide range of coverage here
around 900 rows...
seems.. This command does not work for this selection.

if i try running this macro for 2-3 rows, it works but even removes the
formatting in these selected rows ...
can you suggest me some other solutions to this that could retain the
formatting...?

Also i had not created these links on this sheet.. it came sporadically...
can be seen even on blank cells...

Any other solutions? (i m using MS Excel 2003 (11.5612.5606) version)


"Dave Peterson" wrote:

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