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

Video duration: 7:46

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

## 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)

#### 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
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.

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

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.