+ Reply to Thread
Results 1 to 3 of 3

VB Code to modify multiple hyperlinks

  1. #1
    Forum Contributor
    Join Date
    06-29-2010
    Location
    Boston, Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    111

    VB Code to modify multiple hyperlinks

    Hello,

    I am looking for help in creating a code that will modify a small part of an embedded hyperlink. I do not want to change the displayed name, so "Report #1" would remain and only the underlying hyperlinks would change. The hyperlinks are specific to the user, so plan on having each hyperlink contain the phrase "USERNAME". The code would have a pop out message box asking for the user's name. Once the user enters the name, selecting OK would initiate a find and replace for all hyperlinks, adding the specific name in place of USERNAME.

    I found the following Microsoft Word code, which has a similar mechanism, but requires the entire hyperlink path. I am trying to make this as simple as possible for the user, so enter the name once and the workbook would be customized to a specific user.

    Please Login or Register  to view this content.
    Any help or guidance appreciated!
    Last edited by Biased Historian; 05-13-2016 at 01:22 PM.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: VB Code to modify multiple hyperlinks

    This works on the active sheet:

    Please Login or Register  to view this content.
    And this works on all sheets in the active workbook:

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Forum Contributor
    Join Date
    06-29-2010
    Location
    Boston, Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    111

    Thumbs up Re: VB Code to modify multiple hyperlinks

    Worked perfectly- thank you very much for helping on this.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Timestamps for Multiple Columns. Need to Modify the Code
    By bssol in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-11-2022, 03:06 AM
  2. [SOLVED] Help modify code to auto-fit multiple named ranges
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2015, 01:06 PM
  3. [SOLVED] Need to modify VBA Code that copies multiple sheets to a master sheet
    By AXGirl in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-02-2014, 04:37 PM
  4. [SOLVED] Can i modify this code to apply to multiple checkboxes and sheets?
    By stolen_83 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2013, 02:44 PM
  5. [SOLVED] Import multiple CVSs to one worksheet - Modify VBA code
    By EIKA in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-24-2013, 05:57 PM
  6. Modify Code to Run across multiple worksheets in directory
    By tdm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2012, 03:29 PM
  7. Modify code to perform on multiple worksheets
    By rhudgins in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-07-2011, 11:30 AM

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