Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
you can use the worksheet_followhyperlink event to achieve this. E.g. put the following code in your worksheet module Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) If Target.Range.Address = "$A$1" Then 'insert your code here End If End Sub The above will process your code if the hyperlink in cell A1 is invoked. HTH Frank Kevgrn114 wrote: How do I make a hyperlink that will run a specified macro when clicked? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I got it I got it
I was trying to put the code in the general Modules and not in the code on the specific sheet Thank you for the help. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
kevgrn114 wrote:
I got it I got it! I was trying to put the code in the general Modules and not in the code on the specific sheet. Thank you for the help. Hi good to hear Frank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hyperlink - execute a "Back/Previous" type of functionality | Excel Discussion (Misc queries) | |||
Execute Macro automatically after hyperlink | Excel Discussion (Misc queries) | |||
Execute Macro | Excel Discussion (Misc queries) | |||
How do I execute command from button or hyperlink? | Excel Discussion (Misc queries) | |||
button to execute macro | Excel Programming |