Hyperlinks: Opening in new window

[richardcranney]

Hello,

I was just wondering if this is possible.

I have a hyperlink both in on the spreadsheet using the "add hyperlink" function, and also one in a macro from when a button is pressed.

Can I ask, is there anyway of making these hyperlinks open in a new window?

Thanks

Richard

 

[DominicB]

Good morning richardcranney

Sure is :

Selection.Hyperlinks(1).Follow NewWindow:=True

HTH

DominicB