Hi Bob
This problem has also frustrated me, although I only
need "GotFocus".
Would it be possible to "Class" for any object including
shapes on the activesheet and get the GotFocus event. To
compound problems my code is not in the active workbook.
TIA
Sandy
-----Original Message-----
"Matt I" wrote in message
...
I'm trying to trap mouse clicks on a shape that is on a
Worksheet. The SheetBeforeRightClick Event traps mouse
clicks over cells but not over the shape - any
suggestions
for a solution?
Hi Matt,
The only way to do this is to assign a macro to the
OnAction property of
the shape. This will run the specified macro whenever the
user clicks on the
shape. There's no way that I know of to trap a right-
click over a shape.
--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/
* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
.