+ Reply to Thread
Results 1 to 3 of 3

remove all Hyperlinks at one time.

  1. #1
    afglass
    Guest

    remove all Hyperlinks at one time.

    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.

  2. #2
    Don Guillett
    Guest

    Re: remove all Hyperlinks at one time.

    not too hard

    Sub HyperlinksOut()
    ActiveSheet.Hyperlinks.Delete
    End Sub

    --
    Don Guillett
    SalesAid Software
    donaldb@281.com
    "afglass" <afglass@discussions.microsoft.com> wrote in message
    news:0EB77691-3392-4BE5-A38D-CD34D247F92F@microsoft.com...
    > 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.




  3. #3
    Gord Dibben
    Guest

    Re: remove all Hyperlinks at one time.

    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"
    <afglass@discussions.microsoft.com> 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.



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1