Hyperlinks

[waderw]

Anyone know if it possible to run modules/macros using hyperlinks?

Thanks,

 

[brettvba]

no only if you were to link the hyperlink to another workbook and when that workbook opened it autoran a macro otherwise I'm pretty sure thats a no

i think you can only attach macros to objects

 

[Ivan F Moala]

On 2002-05-02 19:50, waderw wrote:
Anyone know if it possible to run modules/macros using hyperlinks?

Thanks,

You can run a macro if from a hyperlink if
you are using xl2000.
Use the sheets FollowHyperlink Event
In the sheet with the Hyperlinks you can do
something like this;

<pre/>
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Select Case Target.Parent

Case "Sheet3!A1"
Call MyMacro1
Case "Sheet3!A2"
Call MyMacro2
End Select
End Sub
</pre>

The Target.Parent is the Name of the
Hyperlink that you click.