+ Reply to Thread
Results 1 to 11 of 11

Change multiple different hyperlinks to display "generic" text globally

  1. #1
    Registered User
    Join Date
    01-20-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Change multiple different hyperlinks to display "generic" text globally

    I have a large number of different hyperlinks to various different websites in different cells in Excel (2003) and I am trying to change the viewable text in ALL these cells to a simple word link "weblink" rather than see all the hyperlink address.

    I know it can be done manually by right-clicking the cell and "Edit Hyperlink" but I would like to do this globally everywhere I have a hyperlink so it doesn't take my all of my natural life to complete the task. Can anyone provide direction?

    Thank you.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,124

    Re: Change multiple different hyperlinks to display "generic" text globally

    You can use this in the immediate window.

    VBE (ALT+F11 )
    Immediate window (CTRL+G)

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-20-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Change multiple different hyperlinks to display "generic" text globally

    Thank you very much, Andy!

  4. #4
    Registered User
    Join Date
    01-21-2011
    Location
    South Louisiana
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Change multiple different hyperlinks to display "generic" text globally

    Quote Originally Posted by Andy Pope View Post
    You can use this in the immediate window.

    VBE (ALT+F11 )
    Immediate window (CTRL+G)

    Please Login or Register  to view this content.
    I tried to use the above but it didn't work for me. Is there some way I have to activate the command?

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,124

    Re: Change multiple different hyperlinks to display "generic" text globally

    You simply type the line in the immediate window and press ENTER to execute the line of code.

  6. #6
    Registered User
    Join Date
    11-11-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Change multiple different hyperlinks to display "generic" text globally

    Fantastic, just used this, thanks!

  7. #7
    Registered User
    Join Date
    10-27-2015
    Location
    Atlanta, Georgia
    MS-Off Ver
    2010
    Posts
    1

    Re: Change multiple different hyperlinks to display "generic" text globally

    Hi Andy. Just did this and you saved my life. Thanks!

  8. #8
    Registered User
    Join Date
    01-29-2016
    Location
    USA
    MS-Off Ver
    2013
    Posts
    1

    Re: Change multiple different hyperlinks to display "generic" text globally

    I select all the hyperlinks in my column and perform this but it only changes the text to display in the first link.

  9. #9
    Registered User
    Join Date
    09-06-2016
    Location
    austin
    MS-Off Ver
    10
    Posts
    1

    Re: Change multiple different hyperlinks to display "generic" text globally

    Is there a way to isolate the text to a column? instead of all hyperlinks.

  10. #10
    Registered User
    Join Date
    05-15-2017
    Location
    Boston
    MS-Off Ver
    2010
    Posts
    1

    Re: Change multiple different hyperlinks to display "generic" text globally

    OMG thank you so much you saved my life!! AndyPope!

  11. #11
    Registered User
    Join Date
    09-06-2017
    Location
    Wausau, WI
    MS-Off Ver
    2013
    Posts
    1

    Re: Change multiple different hyperlinks to display "generic" text globally

    Allow me to add another enthusiastic THANK YOU!

+ 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