Captain_Jack_T
New Member
- Joined
- Nov 6, 2012
- Messages
- 27
Hi guys
I have the following Event:
The Hyperlink leads to a worksheet. do you know how i can select the sheet, where the Hyperlink brings me to? ActiveSheet.select results in selecting the sheet, on which the event code is written.
Thanks!
Captain
I have the following Event:
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim n As Integer
n = Range("A1").End(xlDown).Row
If Target.Column = 1 And Target.Row <= n And Target.Row > 3 Then
Target.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
frmCapture.Show
End If
End Sub
The Hyperlink leads to a worksheet. do you know how i can select the sheet, where the Hyperlink brings me to? ActiveSheet.select results in selecting the sheet, on which the event code is written.
Thanks!
Captain