+ Reply to Thread
Results 1 to 8 of 8

Excel 2007 : show the actual URL in column of hyperlinked cells...

  1. 07-06-2010, 10:37 AM #1
    naytu
    naytu is offline
    Registered User
    Join Date
    07-06-2010
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2007
    Posts
    1

    show the actual URL in column of hyperlinked cells...

    Hello clever technically-inclined people.... I am trying to figure something out in excel and maybe you can help me.

    Im using excel 2007 - Basically, I have a column of hyperlinked cells in excel, I need to show the actual URL / Web address and not just the text thats been superimposed over the URL, I know I can do this individually by clicking each cell, going to edit hyperlink and deleting the “text to display” but is there anyway of just bulk doing it for a whole column?

    Any help would be greatly appreciated!...
    !
    Reply With QuoteRegister To Reply
  2. 07-06-2010, 10:46 AM #2
    Ron Coderre
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: show the actual URL in column of hyperlinked cells...

    The below VBA code replaces the cell text (of hyperlinked cells) with the hyperlink address:

    • ALT+F11 to open the Visual Basic Editor
    • Select your workbook name from the project window
    • Insert.Module
    • Copy the below code and paste it into that module:
    Please Login or Register  to view this content.
    • Switch to your worksheet
    • Select the range of hyperlinked cells
    • ALT+F8...to see the list of available macros
    • Choose: ReplaceCellTextWithHLinkAddress
    • Click: Run

    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules
    Reply With QuoteRegister To Reply
  3. 09-14-2012, 12:55 PM #3
    bobx
    bobx is offline
    Registered User
    Join Date
    09-14-2012
    Location
    West Berkshire, England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Excel 2007 : show the actual URL in column of hyperlinked cells...

    Exactly what I needed, thanks!
    Reply With QuoteRegister To Reply
  4. 09-17-2012, 01:35 AM #4
    MYORCHID26
    MYORCHID26 is offline
    Registered User
    Join Date
    09-17-2012
    Location
    CA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: show the actual URL in column of hyperlinked cells...

    Hi,
    I tried the code that you advised and it didn't work. Can you assist? I copied it into a file thats attached. I have the same issue I need help with. I want to activate all of the hyperlinks in column Q without having to click one by one.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 09-17-2012, 04:01 AM #5
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Excel 2007 : show the actual URL in column of hyperlinked cells...

    Myorchid26,

    Welcome to the Forum, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
  6. 10-21-2012, 03:17 AM #6
    bholabhala
    bholabhala is offline
    Registered User
    Join Date
    03-06-2004
    Posts
    53

    Re: Excel 2007 : show the actual URL in column of hyperlinked cells...

    Awesome. Thank you so much
    Reply With QuoteRegister To Reply
  7. 02-05-2013, 02:31 PM #7
    handsun
    handsun is offline
    Registered User
    Join Date
    02-05-2013
    Location
    Ocala, Florida
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Excel 2007 : show the actual URL in column of hyperlinked cells...

    Wow, Just what I needed and forget about trying to write this myself! Thanks, got my work done this afternoon!!
    http://dukeinsuranceagency.com
    Reply With QuoteRegister To Reply
  8. 04-19-2013, 05:07 PM #8
    lorif
    lorif is offline
    Registered User
    Join Date
    01-11-2013
    Location
    houston
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Excel 2007 : show the actual URL in column of hyperlinked cells...

    Thanks so much! I tried to follow the instructions for this on 2 other sites and couldn't get it work. this worked perfectly. Thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1