activate sheet only using hyperlink
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 *** |
All times are GMT +1. The time now is 12:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com