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;

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

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