i want to activate specific sheet only,,, namely not cell is activated.
only sheet....
cells(2,3).value=sht.name
cells(2,3).Hyperlinks.Add Anchor:=cells(2,3),Address:=ShtName

below source is not...
With Cells(ro, col)
.Value = sht.Name
.Hyperlinks.Add Anchor:=.Cells, Address:="", SubAddress:=
_
"'" & .Value & "'!A1",
TextToDisplay:=.Value
end With


*** Sent via Developersdex http://www.developersdex.com ***