preventing excel from launching a new browser for each hyperlink

[Guest]

Excel launches a new browser window for each and every hyperlink clicked from a spreadsheet. This is very inconvinient for me, so is there a way to make excel to use the already open browser window for the links within the spreadsheet?

 

[Gord Dibben]

zop

Isn't that a Windows setting?

In My Computer>Tools>View>Explorer. Uncheck "launch browser windows in a
separate process".

Gord Dibben Excel MVP

 

[Guest]

I checked that and it was already unchecked. I think that setting is for windows explorer and doesn't affect internet explorer settings.

 

[Ron de Bruin]

Hi

If you copy the web links in a range as text
Maybe you can use this open the link that is in the Activecell
Run the sub Run1 with a web address in the Activecell

Option Explicit

Private Declare Function GetDesktopWindow Lib "user32" () As Long

Private Declare Function ShellExecute Lib "shell32.dll" _
Alias "ShellExecuteA" _
(ByVal hwnd As Long, ByVal lpOperation As String, _
ByVal lpFile As String, ByVal lpParameters As String, _
ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long


Public Sub RunShellExecute(ByVal sFile As Variant)
Dim hWndDesk As Long
Dim success As Long
Const SE_ERR_NOASSOC = &H31
hWndDesk = GetDesktopWindow()
success = ShellExecute(hWndDesk, "Open", sFile, 0&, 0&, 3)
End Sub

Sub Run1()
RunShellExecute ActiveCell.Value
End Sub

--
Regards Ron de Bruin
http://www.rondebruin.nl

I checked that and it was already unchecked. I think that setting is for windows explorer and doesn't affect internet explorer

settings.

 

[Guest]

That works, thanks a bunch