+ Reply to Thread
Results 1 to 4 of 4

Hyperlink to Text? Hyperlink to a Picture Embedded on a Worksheet?

  1. #1
    Registered User
    Join Date
    01-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    2

    Hyperlink to Text? Hyperlink to a Picture Embedded on a Worksheet?

    Hi, there's gotta be a simple solution but I don't know what it is. I don't know OLE or VB or whatever programming that might make this happen.

    Let's say A1 is text that says "Office Policies" and is hyperlinked to go to A60 where it also says "Office Policies." <----that part's easy.

    But how can I configure the hyperlink so that if somebody inserts 3 rows between rows 1 and 60, and the text that says "Office Policies" is now in cell A63, that the hyperlink WILL GO TO A63 and automatically adjust for inserted (or deleted) rows?

    If I could hyperlink to a thumbnail picture on the worksheet that says "Office Policies," that would be easy but I don't know how or if I can.

    Excel 2007 and also 2003
    Thanks for your help!
    Jcj
    Last edited by jcj785; 01-13-2012 at 12:11 PM.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Can I Hyperlink to Text? Can I Hyperlink to a Picture Embedded on a Worksheet?

    Hello

    It is easier of you use named ranges.
    e.g.
    Lets say the word "Office Policies is in Cel A60.
    click it go to Formula menu - define name - give it a name like e.g. SAMPLER
    Now go to A1 for your hyperlink

    enter
    =hyperlink("#SAMPLER","Office Policies")

    now even if you insert rows it will search and go to the named ranged "SAMPLER".
    HTH
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Hyperlink to Text? Hyperlink to a Picture Embedded on a Worksheet?

    In A1, use:

    =HYPERLINK("#A"&MATCH("Office Policies",A2:A65536,0)+ROW(A1),"Office Policies")
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  4. #4
    Registered User
    Join Date
    01-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Hyperlink to Text? Hyperlink to a Picture Embedded on a Worksheet?

    Thanks guys! Both of these work. I appreciate your help! Jcj

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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