HyperLinking
HyperLinking
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: HyperLinking

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Qld, Australia
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi,

    I was wondering if anyone can tell me how, if at all, it is possible to hyperlink to a text box. I have been able to name the text box in the name define area but it doesnt appear when I go to hyperlink > place in this document > define names.

    Any suggestions. If all else fails I can hyper link to the cell behind the text box, but I was hoping it was possible to achieve the above.

    Thankyou in advance for any help.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The HYPERLINK Help topic states, "Link_location can refer to a place in a document such as a specific cell or named range in a Microsoft Excel worksheet or workbook".

    A range [of cells] includes a reference for the cell in the upper-left corner of the range, a colon (, and then the reference to the cell in the lower-right corner of the range. For example, A10:B20 is a cell range which can be named using the Insert | Name Define... menu command.

    [ This Message was edited by: Mark W. on 2002-02-27 17:15 ]

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    St. Paul, Minnesota, USA
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have had the same question for some time - only I am trying to set up a hyperlink to a graphic object (an imported photo).

    Excel will give a generic name to an imported photo (e.g. "Picture 1"), and if you click on the picture, "Picture 1" appears in the "name" field. You can even change the generic name to something else ("Bob") by clicking in the "name" field and typing. In this respect, it's identical to giving a name to a specific cell.

    However this name does NOT appear in the list of Defined Names if you go to Insert>Hyperlink>Bookmark.

    In short, it looks to me like Excel "kind of" can give a graphic object a name, but not really.

    Does anyone else have an answer to this?

    Thanks.

  4. #4
    New Member
    Join Date
    Feb 2002
    Location
    Qld, Australia
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yep that is it exactly Dennis. When you click on the textbox it gives the name 'text box #' but you cant seem to link to it.

    Seems strange that you are able to define the name, or at least put a name in the name box, yet it doesnt really recognise the name.

    I hope somebody else has overcome this problem, most probably something quite straight forward.

    Thanks.

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    Cape Town,South Africa
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi Tube

    If you select the range into which you want to place your hyperlink,press Ctrl+K and the range is hyperlinked.


User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com