Linking to sheets Macro

I have an excel worsheet with a bunch of sheets with different names

I want a macro that creates a new sheet with links to all the other sheets, the link should be the name of the other sheets.

Try this macro when the sheet on which you want the hyperlinks to appear is the one which is active.

Please Login or Register  to view this content.

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007/2010.

Thanks mrice

Only problem is that when I click on one of the links it tells me :

reference is not valid.

Note that i added a small bit to the code so that it would create a new sheet in the front.

Note that my first sheet was calledstage1

Please Login or Register  to view this content.

Just to mention that

Please Login or Register  to view this content.

is more robust in the case where there are spaces in the names of the sheets.