Target Frame

[Guest]

Asked this in another forum but no answer so trying here

First, thanks to this group for helping me with my
challenges.

I am publishing a spreadsheet through our intranet. I am
leaving it in XLS format rather than htm because the users
need to be able to save the sheet locally.

In one column I am using the command =hyperlink (a1) to
translate a text link from SQL to a real hyperlink. That
works very well (thanks group)

BUT..... How can I set the target frame reference in the
=hyperlink column so it opens a new window? I cannot seem
to open any command to make it open a new window. When
the user clicks on the link, it prompts them to save the
xls sheet.

Art

 

[Dave Peterson]

Maybe you could toss the =hyperlink() formula.

then make a doubleclick on the cell launch the link:

Option Explicit
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _
Cancel As Boolean)

If Target.Cells.Count > 1 Then Exit Sub
If Trim(Target.Value) = "" Then Exit Sub

If Intersect(Target, Me.Range("a:a")) Is Nothing Then
Exit Sub
End If

Cancel = True 'stop from editing in cell

ThisWorkbook.FollowHyperlink Address:=Target.Value, NewWindow:=False

End Sub