Open hyperlink in Excel in same web browser

[bdbBear]

I have a range of cells that I iterate through and add hyperlinks to using code like this:

With Worksheets("Sheet1").Hyperlinks.Add anchor:=Worksheets("Sheet1").Range("E9"), _
Address:=cHLink, TextToDisplay:=cName

When the user clicks on the hyperlink, each time a different browser is opened. Is there a way
to have the existing (if there is one) browser be used?

Thanks!

 

[BobEulberg]

Go to Control Panel > Internet Options > Advanced tab. You should find a checkbox with the caption 'Reuse windows for launching shortcuts.' If that is checked it should open the link in the existing window if there is one.

No clue how you'll change that setting if you need to, but maybe this will be a start.

Thanks, Bob

 

[bdbBear]

Thanks Bob!

Now I just have figure how to do this programmatically ... probably an API call to the registry?!!!

- Bruce