In Excel 2000. Is ther a way to remove all hyper links at one time. The
worksheet that I'm using is 674 lines long, and about 1/2 of them have
hyperlinks.
In Excel 2000. Is ther a way to remove all hyper links at one time. The
worksheet that I'm using is 674 lines long, and about 1/2 of them have
hyperlinks.
not too hard
Sub HyperlinksOut()
ActiveSheet.Hyperlinks.Delete
End Sub
--
Don Guillett
SalesAid Software
[email protected]
"afglass" <[email protected]> wrote in message
news:[email protected]...
> In Excel 2000. Is ther a way to remove all hyper links at one time. The
> worksheet that I'm using is 674 lines long, and about 1/2 of them have
> hyperlinks.
Sub removeAllLinksFromSelection()
Selection.Hyperlinks.Delete
End Sub
If not familiar with macros see David McRitchie's getting started page.
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Gord Dibben Excel MVP
On Sun, 2 Jan 2005 04:53:05 -0800, "afglass"
<[email protected]> wrote:
>In Excel 2000. Is ther a way to remove all hyper links at one time. The
>worksheet that I'm using is 674 lines long, and about 1/2 of them have
>hyperlinks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks