+ Reply to Thread
Results 1 to 2 of 2

Using a hyperlink to select a cell and instantly activate that cell's hyperlink

  1. #1
    Registered User
    Join Date
    10-31-2016
    Location
    Arizona
    MS-Off Ver
    2010
    Posts
    2

    Question Using a hyperlink to select a cell and instantly activate that cell's hyperlink

    Hi! I am creating a database. One sheet has a sort-able table of contents, and the other sheets have the specific data relevant to their headings. I already have made it so that I can hyperlink from the table of contents to the specific pages, but I am having trouble going the other way.

    One thing this project needed was the ability to select sort-able data, so I created a peripheral sheet that handles hyperlinking back to the sort-able table of contents. What I am trying to achieve is a way to link from the specific data pages back to the table of contents in only 1 click, rather than clicking a hyperlink from the specific data pages to the peripheral sheet, and then clicking another hyperlink from the peripheral sheet to the table of contents.

    On my peripheral sheet I am using this method to maintain the integrity of the hyperlinks and still allow it to be searchable.

    To be brief, is there a way to create sort of a "pass-through" hyperlink where you click one thing, it goes to another which is instantly activated, and then takes you to a third place?

  2. #2
    Registered User
    Join Date
    10-31-2016
    Location
    Arizona
    MS-Off Ver
    2010
    Posts
    2

    Re: Using a hyperlink to select a cell and instantly activate that cell's hyperlink

    bump for visibility

+ 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. Hyperlink to activate cell(s) in other worksheet of same workbook
    By milt2010 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2016, 06:20 PM
  2. [SOLVED] Enter a number in a Textbox then find the number in a cell to activate Hyperlink
    By lapot in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-06-2014, 10:26 AM
  3. [SOLVED] Excel 2010 Create a macro to check if cell contains hyperlink then apply hyperlink style
    By chasidar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2013, 04:48 AM
  4. Replies: 7
    Last Post: 06-02-2013, 07:23 PM
  5. Select cell containing hyperlink after activation
    By Zimbo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-27-2009, 05:42 AM
  6. [SOLVED] How do I create a hyperlink to a cell with the hyperlink function
    By S. Bevins in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-20-2006, 03:06 PM
  7. [SOLVED] script to hyperlink and reference a cell value in the hyperlink
    By Natasha D. in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-17-2006, 02:43 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