+ Reply to Thread
Results 1 to 6 of 6

Hyperlinking using VBA

  1. #1
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Hyperlinking using VBA

    Hi

    Can anyone provide me with a code to automatically create links from a "Summary" Sheet, to new sheets created in the same file.
    The new sheets are named from data in column "O" of the "Summary" Sheet.

    I presume the concept is like if the data in column "O" of the "Summary" sheet exists as an actual worksheet (as named from column "O" of the "Summary" sheet, then the links will be automatic.
    If it helps, the newly created sheet also has the sheet name in Cell B1.

    Is this possible?
    Last edited by Christopherdj; 03-22-2015 at 08:42 PM.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Hyperlinking using VBA

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Re: Hyperlinking using VBA

    Here is a sample file attached.
    It would be good to double click on the client ID in both the summary page and individual Client sheet if possible.
    But if I have to use the data in column M (summary page) and B1 of the client sheets, then that's ok.

    My needs are: When I've created a sheet for a new client, I want to automatically create the event to allow users to go from the summary page to the client sheet that is double clicked on.
    Attached Files Attached Files
    Last edited by Christopherdj; 03-22-2015 at 08:14 PM.

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Hyperlinking using VBA

    Hi Chris,

    It didn't take as long as I had feared:Event Scenario March 2015.xlsm

  5. #5
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Re: Hyperlinking using VBA

    Sheer brilliance again. Thanks. I'd give you another Rep, but it won't let me :-(

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Hyperlinking using VBA

    You're welcome!

+ 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. Is this possible? Hyperlinking..
    By kevingall in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-11-2013, 06:12 PM
  2. Hyperlinking help
    By greatwhitenorth in forum Excel General
    Replies: 1
    Last Post: 04-04-2013, 04:52 PM
  3. Need hyperlinking help
    By Cyrric in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-27-2009, 09:33 AM
  4. Hyperlinking
    By MAQurashi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-31-2008, 05:14 PM
  5. Excel 2007 : Help with hyperlinking
    By lindty72 in forum Excel General
    Replies: 1
    Last Post: 10-28-2008, 02:58 PM

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