+ Reply to Thread
Results 1 to 6 of 6

how to find and remove non active hyperlinks

  1. #1
    Registered User
    Join Date
    05-02-2007
    Posts
    8

    how to find and remove non active hyperlinks

    Hi, I am using excel 2007 and have a large list data in a single column that is hyperlinked. however many in this list may have the blue font color like the hyperlinked ones but have no url associated with them.

    What I need to be able to do is have excel locate all these false linked cells and change there font color to normal then from there I can sort everything by font color and makes it easy to find and fix these fields.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: how to find and remove non active hyperlinks

    If your hyperlinks are to cells within the workbook, maybe this link will provide a starting point to modifying some code to get the job done.

    http://www.ozgrid.com/forum/showthread.php?t=89724

    If you are asking if Excel can validate whether or not the url of a hyperlinks is still valid, I think that is likely not possible. I'm sure one of the Forum Guru's will respond if there is way.

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: how to find and remove non active hyperlinks

    Maybe like this:
    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    05-02-2007
    Posts
    8

    Re: how to find and remove non active hyperlinks

    Thanks, though need a bit of help on how to use it. I know to place the code into the workbook by alt+F11.. from there not sure how to go about making use of it.

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: how to find and remove non active hyperlinks

    Please Login or Register  to view this content.
    Adding a Macro to a Code Module
    1. Copy the code from the post
    2. Press Alt+F11 to open the Visual Basic Editor (VBE)
    3. From the menu bar in the VBE window, do Insert > Module
    4. Paste the code in the window that opens
    5. Close the VBE to return to Excel

    Before closing the VBE, change Columns(1) to whatever is the column of interest.

    Back in Excel, do Alt+F8 and run macro x.

  6. #6
    Registered User
    Join Date
    05-02-2007
    Posts
    8

    Re: how to find and remove non active hyperlinks

    Many thanks, it worked perfectly. Also that info helped me get another formula working for something else I gave up on some time back.

+ 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