Listing sheets in a workbook and then hyperlinking them.

**DannyJ** · 10-05-2012, 07:34 AM

Hi All,

I am back for more advice! Someone in another thread asked for code to list all worksheets in a workbook. I have written the code for that but would like to take it one step further and hyperlink all the sheets names. How would I do this please?

The code that I used was as follows:

Please Login or Register  to view this content.

Thanks in advance

Danny

**Patnaik** · 10-05-2012, 10:12 AM

Hello DannyJ

you Can use the Below Code for index of Sheets with Hyper Links, I think the below code will help you

Please Login or Register  to view this content.

With Regards

Patnaik

**DannyJ** · 10-05-2012, 11:23 AM

Patnaik,

Thanks for your response but that hasn't created any hyperlinks?

They also need to be in the Master Sheet

Regards

Danny

**Patnaik** · 10-06-2012, 12:21 AM

Hi DannyJ

With my before code it's create index sheet for all sheets and create the sheet names with hyperlinks, if that is not work
can you upload a sample file

With Regards

Patnaik

**JBeaucaire** · 10-06-2012, 12:56 AM

CREATE A HYPERLINKED LIST OF SHEETS IN A WORKBOOK ON A FRONT SHEET

This macro creates a "table of contents" on a sheet at the beginning of the workbook. Each sheet listed is also an active Hyperlink so click the name will take you directly to the sheet. It demonstrates how to also collect some key pieces of data from each sheet to add to the LIST sheet to be more informative. It puts a link on all your original sheets in cell A1 back to this new LIST sheet and you have an extremely fast navigation system for large workbooks. There's a sample file for you to see this operate.

Create Hyperlinked List of Sheets

Once the hyperlinks are created for you, you could reorganize them on that front sheet in any visual way you wish to make them easy to see all at once.