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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create Hyperlink in VBA 7
OPENING SEVERAL HYPERLINKS 7
hyperlinks saving error in code 2
Open folder with code 5
macro to open a document 6
Replace Hyperlink Addresses Help 'Dim OldStr As String, NewStr As String 6
Screen alerts 6
Auto_Open - Prompt to Continue? 2

Back
Top