Say we start with MyMacro in a standard module and some picture on the
worksheet.

1. right-click the picture and assign a hyperlink to a place in this document
2. make the place IV65536
3. settup your tooltip

So now if you mouse-over the picture you should see the tooltip; if you
click the picture you should go to IV65536

4. next right-click the tabname and pick View code; gets you to the
worksheet code area.
5. install the following event macro:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, Range("IV65536")) Is Nothing Then
Else
Call MyMacro
Application.Goto
End If
End Sub


MyMacro will run and the Goto gets you back from IV65536.

Have Fun!
--
Gary''s Student - gsnu200855


"kirkm" wrote:

On Fri, 29 May 2009 03:12:01 -0700, Gary''s Student
wrote:

You can create a popup message on mouse-over by assigning a hyperlink to the
picture.

It does not matter where the hyperlink links to, you intercept the hyperlink
event and run your macro from the event code.

Basically you use an indirect approach; your macro is not assinged to the
picture, it is called by the hyperlink event macro.

Thanks Gary... but could you give more details plse? I couldn't get
my assigned macro to start via a Hyperlink, and also the Tip was
positioned on column1, nowhere near the picture. Couldn't see where
you change that.

Cheers - Kirk