+ Reply to Thread
Results 1 to 4 of 4

Using a Hyperlink to move to another sheet without the http:// or macro

  1. #1
    Registered User
    Join Date
    11-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2016
    Posts
    2

    Using a Hyperlink to move to another sheet without the http:// or macro

    Hello,

    I need to create a button/hyperlink to move from sheet to sheet within the same excel file. When I do a regular hyperlink, it includes the whole path of the file and when send the file to another person, the links do not work because it is pointing towards the file on my computer. Just need to have it jump within the file, not out and back in.

    I thought about using a VB or Macro but the school will not let me do that for security reasons so I need to stay within the file itself.

    Any help or other ideas would be greatly appreciated.

    Thanks

    Jeff

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,944

    Re: Using a Hyperlink to move to another sheet without the http:// or macro

    Hi, welcome to the forum

    You can probably remove teh file name/path from teh HL, but here is another way to do this...
    =HYPERLINK("#"&"'"&A2&"'!A1",A2)
    This takes the sheet name from A2, and uses that for the H/L to cell A1 in that sheet
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,944

    Re: Using a Hyperlink to move to another sheet without the http:// or macro

    If you dont want to have the sheet names in a list, you can use thism and then just hard code the names...
    =HYPERLINK("#"&"'Sheet4'!A1",A2)

  4. #4
    Registered User
    Join Date
    11-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2016
    Posts
    2

    Re: Using a Hyperlink to move to another sheet without the http:// or macro

    That worked like a charm! Thanks!

+ 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 Error HTTP/1.0 404
    By Shazardred in forum Excel General
    Replies: 5
    Last Post: 10-28-2015, 07:20 PM
  2. [SOLVED] Move a hyperlink to a new sheet based on a cell value
    By rosshkerr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-20-2015, 04:21 PM
  3. Replies: 8
    Last Post: 01-30-2014, 03:12 PM
  4. macro to move 1 cell left and paste CURRENT clipboard content as HYPERLINK
    By sgoesef in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2013, 01:31 PM
  5. Replies: 5
    Last Post: 06-22-2006, 07:10 AM
  6. Replies: 0
    Last Post: 03-26-2006, 07:10 PM
  7. Replies: 1
    Last Post: 06-23-2005, 02:05 PM

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