ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   hyperlink (https://www.excelbanter.com/excel-programming/310752-hyperlink.html)

Bruni

hyperlink
 
I used that code to open the hyperlink in a new window...

Private Sub Worksheet_FollowHyperlink(ByVal Target As
Hyperlink)

Application.EnableEvents = False
Target.Follow NewWindow:=True
Application.EnableEvents = True

End Sub

Id like to know if its possible to avoid that the main
page open the hyperlink also


All times are GMT +1. The time now is 01:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com