Hi,
I am trying to Hyperlink sheet3 in Cell B7 of sheet1 .
I used the following code .
But none of them seem to be wrkg.
xlsobj.Worksheets(1).Hyperlinks.Add Anchor:=xlsobj.Worksheets(1).Range("B7"), Address:="Worksheet(3)", SubAddress:=xlsobj.Worksheets(3).Range("A1").Address, TextToDisplay:="Back <<"
xlsobj.Worksheets(1).Hyperlinks.Add Anchor:=xlsobj.Worksheets(1).Range("B7"), Address:="Sheet3!A1", TextToDisplay:="Back <<"
Is there any other way to hyperlink sheets?
Bookmarks