I've only seen the formatting get removed from the cells that had the
hyperlink. Other cells remained unchanged. I don't have a way to retain all
the formatting for those cells.

And I've never seen it fail no matter how large the selection is. In fact, I've
removed all the hyperlinks from the whole sheet with no problems.

chits wrote:

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


--

Dave Peterson