+ Reply to Thread
Results 1 to 4 of 4

Hyperlink to activate cell(s) in other worksheet of same workbook

  1. #1
    Registered User
    Join Date
    12-29-2010
    Location
    Italy
    MS-Off Ver
    Excel 2003
    Posts
    34

    Hyperlink to activate cell(s) in other worksheet of same workbook

    Hello!

    I would like to have some cells (with values "1", "2", "3" and "4") that I put in, to work as hyperlinks to another worksheet in the same workbook.

    I have this code that do it but only for the first value, the "1":
    Please Login or Register  to view this content.
    I attach an Excel file and a very little video to view online http://sendvid.com/b1gz84cq to a better understanding of what I want to do.

    In this file, the value "1" in worksheet "List", is related to the definition "Area". So with rigth click on cell(s) with value(s) "1" the link will open the corresponding linked cell in the column under the name "Area" in the worksheet "Respons". I would that the same thing happen clicking on other cells (with values "2", "3" and "4") activating the relatives cell(s) under "District" (2), "Sector" (3) and "Group" (4).

    So, I would like that cell(s) that contain the value(S) "1", "2", "3" or "4", when I click with the right mouse button, it link to the worksheet "Respons". You can see how the attached file work with right click on cell(s) with value "1".

    It is possible to modify the code to do this?

    Thanks in advance
    Attached Files Attached Files
    Last edited by milt2010; 02-21-2016 at 04:27 AM.

  2. #2
    Registered User
    Join Date
    12-29-2010
    Location
    Italy
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Hyperlink to activate cell(s) in other worksheet of same workbook

    No one can help???

  3. #3
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Hyperlink to activate cell(s) in other worksheet of same workbook

    maybe like this ?

    Please Login or Register  to view this content.
    Kind regards
    Leo

  4. #4
    Registered User
    Join Date
    12-29-2010
    Location
    Italy
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Hyperlink to activate cell(s) in other worksheet of same workbook

    Quote Originally Posted by LeoTaxi View Post
    maybe like this ?

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Yes!!!! YOU'RE MY HERO! It's four days that seeking a solution to this problem!! Thank you so much!

+ 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. Replies: 5
    Last Post: 03-11-2015, 03:13 PM
  2. [SOLVED] how to activate a specific worksheet of a workbook
    By amethystfeb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2014, 11:51 AM
  3. Replies: 7
    Last Post: 06-02-2013, 07:23 PM
  4. Activate the highest/newest worksheet in a workbook
    By Belgarath75 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-21-2011, 08:31 PM
  5. Replies: 1
    Last Post: 08-29-2009, 11:01 PM
  6. Hyperlink selected cell to last worksheet in active workbook.
    By Mr.G. in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2009, 05:45 AM
  7. activate last worksheet in a different workbook
    By Aaron in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-22-2006, 06:55 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