title: Excel VBA : WorkSheet_FollowHyperlink is not getting called for Shape Object ( msoPicture )
body: <p>I need to have a macro executed when someone clicks on the shape in the worksheet which is a picture. The macro intention is to display more information regarding the shape on which the user clicked. 
  EDIT: I also needed an information display during mouse-rollover, hence used hyperlink method.</p>
  
  <p>I followed the method outlined in the <a href="http://www.google.co.in/url?sa=t&amp;rct=j&amp;q=&amp;esrc=s&amp;source=web&amp;cd=1&amp;cad=rja&amp;uact=8&amp;ved=0CCkQFjAA&amp;url=http://msdn.microsoft.com/en-us/library/office/ff838843%28v=office.15%29.aspx&amp;ei=bng-U7rdC4aIrQe9pYGQAw&amp;usg=AFQjCNFj3kZGaBBQY8IgS5RnodUUchDB6A&amp;bvm=bv.64125504,d.bmk" rel="nofollow">MSDN</a> , but the macro just doesn't seem to run. </p>
  
  <p>My Macro is as follows:</p>
  
  <pre><code>Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    MsgBox "Source: Target.Range.Address  " &amp; Target.Range.Address
    MsgBox "Source: Target.Range.Value " &amp; Target.Range(1, 1).Value
    ' Some more macro stuff here
  End Sub
  </code></pre>
  
  <ul>
  <li>On clicking the picture I get to the sheet where the hyperlink target
  is, but the macro doesn't get executed. </li>
  <li>I created a dummy hyperlink on one of the cells (in the same sheet), if I click that one the macro is executed.</li>
  <li>I used the hyperlink method to have the rollover information on the picture shape.</li>
  </ul>
  
  <p>I am totally out of ideas about how to go about this. Help would be greatly appreciated.</p>