macro's and hyperlinks
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: macro's and hyperlinks

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Netherlands
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Is there a way to start a macro by clicking on a hyperlink ?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,936
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    There certainly is. Say you want a hyperlink in cell A1. In cell A1 click Insert, Hyperlink and press the Bookmark button. Then type A1 in the Cell Reference box. Click OK and OK again. Now right click the worksheet tab and choose View Code. Paste this:-

    Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    YourMacroName
    End Sub

    Where YourMacroName is probably stored in a standard module.

    HTH,
    Dan

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Netherlands
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thank you, this works OK !!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com