Hyperlink to all worksheets

Put this code into a module in the workbook and make sure the sheet you want the hyperlinks to show up on is the active sheet this will put the hyperlinks in cells A1 to A and however many sheets there are. You could just run this code as is, then format the sheet around it cutting and pasting the range of hyperlinks would be okay. Otherwise you can change the initial i value in the code to the first row in which you want the hyperlinks to appear and change the "A" to the column.

Please Login or Register  to view this content.