G
Guest
Can you make a Hyperlink so when you click it runs a macro?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jim Cone
Yes
"pokdbz" <[email protected]>
wrote in message
Can you make a Hyperlink so when you click it runs a macro?
"pokdbz" <[email protected]>
wrote in message
Can you make a Hyperlink so when you click it runs a macro?
G
Guest
First have the hyperlink point to a cell. When the jump is made to the cell,
use an Event to trigger the macro:
In A1 enter:
=HYPERLINK("#sheet1!Z100","leap")
and in worksheet code have something like:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, Range("Z100")) Is Nothing Then
Exit Sub
End If
MsgBox ("hello")
End Sub
REMEMBER: worksheet code, not a standard module.
use an Event to trigger the macro:
In A1 enter:
=HYPERLINK("#sheet1!Z100","leap")
and in worksheet code have something like:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, Range("Z100")) Is Nothing Then
Exit Sub
End If
MsgBox ("hello")
End Sub
REMEMBER: worksheet code, not a standard module.
D
Dave Peterson
If you're using insert|Hyperlink to create those hyperlinks, you may be able to
tie into the Worksheet_FollowHyperlink event.
tie into the Worksheet_FollowHyperlink event.
G
Guest
How?