Mr Excel & excelisfun Trick 76: Worksheet With Hyperlinks That Jump To Each Sheet In The Workbook




About this tutorial:

Video duration: 7:46
Download Files:

See Mr Excel and excelisfun create Dynamic Range For VLOOKUP and Data Validation using the OFFSET and INDEX functions.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

15 thoughts on “Mr Excel & excelisfun Trick 76: Worksheet With Hyperlinks That Jump To Each Sheet In The Workbook

    eLearn

    (February 15, 2020 - 10:39 pm)

    Maybe Transpose formula help you to make it easier like linking and listing.

    FREDBMW528E

    (February 15, 2020 - 10:39 pm)

    Using vba you could code it in a "Before double click" subroutine. That way it is permanent and you don't have to worry about hyperlinks getting erased, etc…

    mariotejas

    (February 15, 2020 - 10:39 pm)

    Mr. Girvin paste this formula in cell C3
    =HYPERLINK("[Book2.xlsx]"&$B3&"!A1", $A$1)
    Thank you both. "Mr Girvin and Mr. Jelen " for all your help.
    Regards,
    Mario Garcia

    ExcelIsFun

    (February 15, 2020 - 10:39 pm)

    I am very sick currently, try THE best Excel question site:

    mrexcel[dot]com/forum

    ExcelIsFun

    (February 15, 2020 - 10:39 pm)

    Cool!

    ExcelIsFun

    (February 15, 2020 - 10:39 pm)

    You are welcome!

    YaNykyta

    (February 15, 2020 - 10:39 pm)

    Great as always!
    Thanks –excelisfun.

    plastikman001

    (February 15, 2020 - 10:39 pm)

    @ExcelIsFun

    Concerning protected sheets; Maybe is it possible to use follwing code.

    ActiveSheet.Unprotect "password"

    ActiveSheet.Protect "password"

    or

    ExcelIsFun

    (February 15, 2020 - 10:39 pm)

    If you want Mr excel to see your comment, you must post at his YouTube Channel, bjele123, or better send him an e-mail:

    pub@mrexcel[dot]com

    –excelisfun

    ExcelIsFun

    (February 15, 2020 - 10:39 pm)

    Cool formula!!!

    arnoldiusss

    (February 15, 2020 - 10:39 pm)

    Maybe a formula approach would be
    =HYPERLINK(MID(CELL("filename");FIND("[";CELL("filename"));FIND("]";CEL("filename"))-FIND("[";CELL("filename"))+1)&B3&"!A1";">>")

    Placed in column A en right align it.
    though It would only work on a saved workbook.
    (Hope i translated the formula right, im working in a dutch version of Excel.)

    ExcelIsFun

    (February 15, 2020 - 10:39 pm)

    I do not have a good solution for you. Sorry. You might ask at the:

    mrexcel[dot]com/forum

    ExcelIsFun

    (February 15, 2020 - 10:39 pm)

    I am glad that you like it!

    Thanks for the 75 catch!

    Elmar Bischof

    (February 15, 2020 - 10:39 pm)

    The problem with this Hyperlinks is that if you hide the sheets and password protect the file structure that it wont work any more.

    Very easy solution to have something similar like that is to create a Button, use the Macro record to jump that certain sheet, stop record and bind it to that Button. By recording this macro you can also hide certain sheets so you see only the one which is just active.

    Unfortunately it also stops working once you pw protect the file.

    bigdad1211

    (February 15, 2020 - 10:39 pm)

    Great video! Very helpful. And the workbook to follow along is 76 , not 75.
    Thanks!!

Leave a Reply

Your email address will not be published. Required fields are marked *