Greetings, I have not been able to find an exact solution for this. I have a vba script to list all worksheets with links into one worksheet but I cannot get it to work on Mac Excel.
Simple script:___________
Sub worksheetlistwithlinks()
Dim sh As Worksheet
Dim cell As Range
For Each sh In ActiveWorkbook.Worksheets
If ActiveSheet.Name <> sh.Name Then
ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"'" & sh.Name & "'" & "!A2", TextToDisplay:=sh.Name
ActiveCell.Offset(1, 0).Select
End If
Next sh
End Sub
______________________
Any guidance is muchly appreciated.
Cheers
Robert
Simple script:___________
Sub worksheetlistwithlinks()
Dim sh As Worksheet
Dim cell As Range
For Each sh In ActiveWorkbook.Worksheets
If ActiveSheet.Name <> sh.Name Then
ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"'" & sh.Name & "'" & "!A2", TextToDisplay:=sh.Name
ActiveCell.Offset(1, 0).Select
End If
Next sh
End Sub
______________________
Any guidance is muchly appreciated.
Cheers
Robert
