Hi
check out the following page
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

(in the middle of this page)


--
Regards
Frank Kabel
Frankfurt, Germany


yankeenica wrote:
how do you delete all hyperlinks in a worksheet but retain the text?

thanks .. .