+ Reply to Thread
Results 1 to 5 of 5

[Hyperlink] How to open a specific sheet without referring to a cell?

  1. #1
    Registered User
    Join Date
    03-11-2014
    Location
    Barbados
    MS-Off Ver
    Excel 2003
    Posts
    18

    Question [Hyperlink] How to open a specific sheet without referring to a cell?

    Is it possible to open a specific sheet of an external workbook without referring to a cell?
    This works fine but it refers to "A1" cell:
    [D:\Test workbook\Book1.xlsm]'Test sheet2'!A1

    And if I remove the cell, it doesn't work anymore:
    [D:\Test workbook\Book1.xlsm]'Test sheet2'

    http://www.mrexcel.com/forum/excel-q...ring-cell.html
    http://www.ozgrid.com/forum/showthre...91125&p=727443
    Last edited by RiP2; 09-25-2014 at 06:09 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: [Hyperlink] How to open a specific sheet without referring to a cell?

    I don't see how this is possible. What are you trying to accomplish?

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: [Hyperlink] How to open a specific sheet without referring to a cell?

    You can create a named range (START) in the target file and the hyperlink will go to that spot.

    C:\Users\USERNAME\Documents\Sample.xlsx#START
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  4. #4
    Registered User
    Join Date
    03-11-2014
    Location
    Barbados
    MS-Off Ver
    Excel 2003
    Posts
    18

    Re: [Hyperlink] How to open a specific sheet without referring to a cell?

    I want it to refer to the last saved range/cell like when you open a saved sheet

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: [Hyperlink] How to open a specific sheet without referring to a cell?

    I don't know if that capability exists or not.

+ 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. Using a cell reference to open a specific sheet within a closed workbook
    By heliwiggy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2014, 12:15 PM
  2. How do I reference another workbook and open a specific sheet named in a cell
    By shabooty542362 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2013, 04:50 PM
  3. Replies: 1
    Last Post: 02-23-2013, 05:18 AM
  4. Replies: 2
    Last Post: 01-19-2013, 09:13 AM
  5. [SOLVED] Open specific sheet depending on cell contents
    By monkey harry in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2006, 11:50 AM

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