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.
Any help or guidance appreciated!Please Login or Register to view this content.
Bookmarks