Forum Discussion
Hyperlinks to worksheets within current workbook
I'm trying to create a sort of Table of Contents as the first worksheet in a workbook, with hyperlinks to other worksheets in the same workbook. Then I want to able to convert this workbook into a st...
Does it work if you use the HYPERLINK worksheet function? to have it point to a location in the file, use the # sign in front of the cell address: =HYPERLINK("#'Sheet 1'!A1","Link to Sheet 1, cell A1")