I have a shape called Oval1.
I would like to set things up so that if a user points the cursor over the shape, then a macro will be activated.
I know how to set things up to activate if the user clicks on the shape:
Sub Oval1_Click()
Do my stuff
End Sub
However, in this new case, I do not want them to have to click - just pass over the shape.
Could someone give me the basic macro-form? Is it a macro associated with the worksheet, as opposed to the shape itself?
Thanks,
MikeG
I would like to set things up so that if a user points the cursor over the shape, then a macro will be activated.
I know how to set things up to activate if the user clicks on the shape:
Sub Oval1_Click()
Do my stuff
End Sub
However, in this new case, I do not want them to have to click - just pass over the shape.
Could someone give me the basic macro-form? Is it a macro associated with the worksheet, as opposed to the shape itself?
Thanks,
MikeG