+ Reply to Thread
Results 1 to 2 of 2

Hyperlinks incorrectly opening a File Folder instead of worksheet tab

  1. #1
    Registered User
    Join Date
    10-14-2015
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    3

    Hyperlinks incorrectly opening a File Folder instead of worksheet tab

    Simple question i hope.

    I use Excel 2013 (although other users of the model use 2010).

    I wanted to allow the user to navigate between various worksheets within the workbook, by clicking on the relevant links. Like a navigation panel.
    All links are to worksheets within that particular workbook. I do not link to external workbooks.

    To do this, I inserted 'shapes' (a text box) into my workbook using the menu ribbon.
    I then right-clicked on the text box and added hyperlinks to this box.
    The hyperlinks went directly to the desired worksheet and worked perfectly.

    Somewhere along the way these have stopped working.
    Now, when i click on the text box, instead of opening the desired worksheet, it will instead open the Folder (using file explorer) in which the Excel file is located.

    When I go back to old versions of the model, the problem is not present (the hyperlinks work appropriately).
    When I create an entirely new workbook, and make new buttons/links, the newly-created links work fine in the new workbook.
    In the current workbook (which i need), I have tried to remove the links and recreate them, and also to copy working links from another workbook.. However, the links open the Folder (using file explorer) in which the Excel workbook is located, instead of navigating to the relevant worksheet within the workbook.

    Thanks for any assistance,
    Ben

  2. #2
    Registered User
    Join Date
    10-14-2015
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    3

    Re: Hyperlinks incorrectly opening a File Folder instead of worksheet tab

    Hi, is anyone available to provide advice on this issue?

+ 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. Try opening a file from a folder without permission
    By crasy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-16-2015, 07:48 AM
  2. [SOLVED] Creating multiple hyperlinks to files in a folder - one file per hyperlink per cell
    By fsusd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-06-2014, 12:17 PM
  3. Adding hyperlinks of folder contents into and excel file
    By Jillenec in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-16-2012, 07:20 PM
  4. Macro For opening Most recent file in folder
    By dtaganovic16 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-13-2012, 12:00 PM
  5. Opening a file that is in a sub folder
    By Mordred in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-10-2010, 11:51 AM
  6. Hyperlinks opening an Excel file at a particular tab
    By PatrickW in forum Excel General
    Replies: 1
    Last Post: 08-23-2005, 02:05 PM
  7. [SOLVED] opening each file in a folder
    By JT in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2005, 02:05 PM

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