Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Nov 2003
    Location
    Louisville, Kentucky, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    hyperlink (excel 97)

    Adding a hyperlink to an excel file that links to another excel file. When I click the link, it hides my original excel file. Why? How can I change this? Is there VB code behind the hyperlink?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: hyperlink (excel 97)

    It doesn't really "hide" it. When you click on the hyperlink to an excel file that file is opened and it becomes the active file.

    If you want some other behavior, you would have to use a routine to open the file, other than a hyperlink. Then you can have complete control over what it does.

    What would you like the routine to do and how do you want to trigger it? Maybe we can help with the coding.

    Steve

  3. #3
    New Lounger
    Join Date
    Nov 2003
    Location
    Louisville, Kentucky, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: hyperlink (excel 97)

    It actually does "hide" it. To go back to the original file, I need to go to "windows - unhide" to view it again.

    The behavior that I want is what you are expecting to happen (and I was too)!

    Thanks.

  4. #4
    New Lounger
    Join Date
    Nov 2003
    Location
    Louisville, Kentucky, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: hyperlink (excel 97)


  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: hyperlink (excel 97)

    Here is a corrected and clickable link.

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: hyperlink (excel 97)

    In my version of XL97, I can not duplicate this.

    When I create hyperlink to another XL file, when I click on the link it just opens the other. If I don't have the windows maximized I can move the top one and the original file is there, not hidden. Pressing the link does open the new file directly over (and the same size) as the "calling" file's window, but It is not "hidden" in any sense other than the new file is directly over it.

    Steve

Posting Permissions

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