Can you make a Hyperlink so when you click it runs a macro?

Yes

"pokdbz"
wrote in message
Can you make a Hyperlink so when you click it runs a macro?

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.
--
Gary''s Student - gsnu200735


"pokdbz" wrote:

Can you make a Hyperlink so when you click it runs a macro?

If you're using insert|Hyperlink to create those hyperlinks, you may be able to
tie into the Worksheet_FollowHyperlink event.

pokdbz wrote:

Can you make a Hyperlink so when you click it runs a macro?

--

Dave Peterson

How?

"Jim Cone" wrote:

Yes

"pokdbz"
wrote in message
Can you make a Hyperlink so when you click it runs a macro?