Opening hyperlinks in separate windows

  • Thread starter Thread starter troysteadman
  • Start date Start date
T

troysteadman

Hi all:

ActiveSheet.Hyperlinks(1).Follow NewWindow:=True
ActiveSheet.Hyperlinks(2).Follow NewWindow:=True

....opens the first two hyperlinks on a sheet in the same window. Can
anyone tell me:

1) How to open them in different windows then reposition those
windows?
2) How to return the addresses of the cells containing the Hyperlinks?

TIA
 
#1 is pretty much out of your hands, it passes the command to open the sheet
to your default browser. You can tell IE to do what you want in the options
but that would have to be set for all the clients you deploy the sheet to. I
couldn't say for sure about the other browsers.

You'd have to make to get the window handle for the browser and move/size
the window using API calls.
 
Back
Top