How do I insert a hyperlink for a worksheet in a workbook?
I have a macro that creates a summary page with all names of the workbook on this summary page. I’d like to add code that would link the cells with the workbook names to the respective worksheets.
Here’s what I have so far.
For Each ws In Sheets
x = x + 1
'x + 1 makes it go to the next row to paste ws.name
Sheets("Summary").Range("A" & x).Value = ws.Name
Next ws
Thanks!
I have a macro that creates a summary page with all names of the workbook on this summary page. I’d like to add code that would link the cells with the workbook names to the respective worksheets.
Here’s what I have so far.
For Each ws In Sheets
x = x + 1
'x + 1 makes it go to the next row to paste ws.name
Sheets("Summary").Range("A" & x).Value = ws.Name
Next ws
Thanks!