Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Target Frame
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Target Frame
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 Art wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create/Edit Hyperlink - Unable to designate target frame | Excel Discussion (Misc queries) | |||
Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
Enable target frame option | Excel Discussion (Misc queries) | |||
How to attach legend frame to chart frame? | Charts and Charting in Excel | |||
how to define target frame names for the hyperlinks in Excel | Excel Programming |