View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Sandy V Sandy V is offline
external usenet poster
 
Posts: 24
Default trapping click events on shapes

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 *



.