I thought this would keep all the links in a sheet I'm clicking on in one window/tab but it's not what am I missing?
Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, ByVal Target As Hyperlink)
ActiveWorkbook.FollowHyperlink Address:=Target.Address, NewWindow:=False
End Sub
Using excel 2007
All the Best,
SL
Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, ByVal Target As Hyperlink)
ActiveWorkbook.FollowHyperlink Address:=Target.Address, NewWindow:=False
End Sub
Using excel 2007
All the Best,
SL
