View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] troysteadman@yahoo.co.uk is offline
external usenet poster
 
Posts: 7
Default 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