+ Reply to Thread
Results 1 to 4 of 4

Remove Hyperlinks

  1. #1
    Otto Moehrbach
    Guest

    Remove Hyperlinks

    Excel XP, Win XP
    I have a list of hundreds of hyperlinked cells scattered throughout more
    hundreds of non-hyperlinked cells. I want to remove the hyperlinks. What
    is the code query for a hyperlinked cell?
    Something like:
    If ActiveCell....hyperlink...=True Then
    Thanks for your time. Otto



  2. #2
    PCLIVE
    Guest

    Re: Remove Hyperlinks

    If you want to remove all hyperlinks in the worksheet.

    Cells.Select
    Selection.Hyperlinks.Delete

    HTH,
    Paul


    "Otto Moehrbach" <ottokmnop@comcast.net> wrote in message
    news:eqXYQK%23tGHA.4544@TK2MSFTNGP04.phx.gbl...
    > Excel XP, Win XP
    > I have a list of hundreds of hyperlinked cells scattered throughout more
    > hundreds of non-hyperlinked cells. I want to remove the hyperlinks. What
    > is the code query for a hyperlinked cell?
    > Something like:
    > If ActiveCell....hyperlink...=True Then
    > Thanks for your time. Otto
    >




  3. #3
    Dave F
    Guest

    Re: Remove Hyperlinks

    If you're using XL XP or 2003 I'm pretty sure there's a way to format
    hyperlinks to appear as regular text (i.e., not live links). Search the help
    function, there may be a simpler way than writing code.

    "PCLIVE" wrote:

    > If you want to remove all hyperlinks in the worksheet.
    >
    > Cells.Select
    > Selection.Hyperlinks.Delete
    >
    > HTH,
    > Paul
    >
    >
    > "Otto Moehrbach" <ottokmnop@comcast.net> wrote in message
    > news:eqXYQK%23tGHA.4544@TK2MSFTNGP04.phx.gbl...
    > > Excel XP, Win XP
    > > I have a list of hundreds of hyperlinked cells scattered throughout more
    > > hundreds of non-hyperlinked cells. I want to remove the hyperlinks. What
    > > is the code query for a hyperlinked cell?
    > > Something like:
    > > If ActiveCell....hyperlink...=True Then
    > > Thanks for your time. Otto
    > >

    >
    >
    >


  4. #4
    acampbell012@yahoo.com
    Guest

    Re: Remove Hyperlinks

    I have the following routine that works

    Sub Remove_Link()
    With Selection
    Selection.Hyperlinks.Delete
    End With
    End Sub


    Otto Moehrbach wrote:
    > Excel XP, Win XP
    > I have a list of hundreds of hyperlinked cells scattered throughout more
    > hundreds of non-hyperlinked cells. I want to remove the hyperlinks. What
    > is the code query for a hyperlinked cell?
    > Something like:
    > If ActiveCell....hyperlink...=True Then
    > Thanks for your time. Otto



+ 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