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

I can answer question 2:

Dim c As String
c = Hyperlinks(1).Range.Address

Mike F
wrote in message
...
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.



" wrote:

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