Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    78

    Question Unanswered: Assign macro to hyperlink

    Is there a way to assign a macro to hyperlink. I want to run a SQL when the hyperlink is clicked.

    Thanks.

    ~BS

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    yup have a look at the

    Code:
    Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
        If Target.Range.Address = Range("A1").Address Then Hello
    End Sub
    repllacing hello with your own sub's name

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •