Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with code to run macros from hyperlinks
Hello
I am using the following code to run a macro from a hyperlink located in cell B13. Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) If Not Intersect(Target.Parent, Range("B13")) Is Nothing Then JacDetailedAnalysisTable End If End Sub The above works fine, but I want to be able to have multiple hyperlinks, each of which runs a different macro. All of the hyperlinks are on the same worksheet. How do I modify the code to achieve this? I tried repeating the code multiple times, changing the cell reference and subroutine name for each hyperlink, but this caused all sorts of problems. Your help would be greatly appreciated. Thanks, Joe. -- If you can measure it, you can improve it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlinks and macros | Excel Discussion (Misc queries) | |||
Hyperlinks & macros | Links and Linking in Excel | |||
Hyperlinks & macros | Excel Discussion (Misc queries) | |||
Changing Hyperlinks in Macros | Excel Discussion (Misc queries) | |||
Using filename hyperlinks in Macros | Excel Programming |