Opening hyperlinks in separate windows
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 |
Opening hyperlinks in separate windows
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 |
Opening hyperlinks in separate windows
#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 |
All times are GMT +1. The time now is 08:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com